Hi,
I want to know how to load XML file data to CSV file or table.
Thanks in Advance
Aswice
How to load XML file data to CSV file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.