I get an single xml with name tags as below:
<eList>
<eDate>
<name>AAA</name>
<value>20090613 00:00:00</value>
</eDate>
<eDate>
<name>BBB</name>
<value>20090614 00:00:00</value>
</eDate>
<eDate>
<name>CCCC</name>
<value>20090615 00:00:00</value>
</eDate>
<eDate>
<name>DDDD</name>
<value>20090616 00:00:00</value>
</eDate>
</eList>
Need to divide the above into multiple columns as below and read it as a single row:
name1=AAA
value1=20090613 00:00:00
name2=BBB
value2=20090614 00:00:00
name3=CCCC
value3=20090615 00:00:00
name4=DDDD
value4=20090616 00:00:00
Processing an XML
Moderators: chulett, rschirm, roy
OK... and what have you tried? You should have a job with a Folder stage and an XML Input stage at the very least. You should also have imported the metadata from your source xml (ideally from an xsd) so you have the appropriate XPath Expressions to use in the XML Input stage to parse this.
And if you haven't done this already, go to Kim Duke's website and download the XML Best Practices document from his Tips&Tricks section. Lots of good information there.
And if you haven't done this already, go to Kim Duke's website and download the XML Best Practices document from his Tips&Tricks section. Lots of good information there.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers