Page 1 of 1

How to load XML file data to CSV file

Posted: Fri Apr 17, 2009 12:41 am
by Gopalraja
Hi,

I want to know how to load XML file data to CSV file or table.


Thanks in Advance
Aswice

Posted: Fri Apr 17, 2009 1:14 am
by ray.wurlod
Read it with an XML Input stage (perhaps fed from a Folder stage).

Beware that one XML file may contain repetition elements, which means that the data are not normalized. If your target requires normalized data then you may require multiple CSV files (Sequential File stage) or tables (database stage type of some kind).