posted 19 years ago
I'm not sure if anyone has done this before but I'd appreciate any suggestions from you.
I have two xml documents. I want to transform the second document using the first document as input. as an ex.
XML1.xml
<ROW num="1">
<EMPNO>7839</EMPNO>
</ROW>
XML2.xml
<ROWSET>
<ROW num="1">
<EMPNO>4235</EMPNO>
<ENAME>BLACK</ENAME>
</ROW>
<ROW num="2">
<EMPNO>4234</EMPNO>
<ENAME>SPARK</ENAME>
</ROW>
</ROWSET>
The transformed document will be
<ROWSET>
<ROW num="1">
<EMPNO>7839</EMPNO>--the value here is from the 1st document
<ENAME>KING</ENAME>
</ROW>
<ROW num="2">
<EMPNO>7788</EMPNO>
<ENAME>SCOTT</ENAME>
</ROW>
</ROWSET>
The first document (input) can contain many elements. I want to search for the occurences of all of them and create the resulting document with the new values.
If you have any questions, let me know.
Thanks in advance,
Srinivas