How to load XML file data to CSV file

Gopalraja · Post by **Gopalraja** » Fri Apr 17, 2009 12:41 am

Hi,

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

Thanks in Advance
Aswice

ray.wurlod · Post by **ray.wurlod** » Fri Apr 17, 2009 1:14 am

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).