I have a Payload file which will come as a .xml file and the contents of it will be as below
Code: Select all
- <ns0:PamMBLotData xmlns:ns0="http://AIG.GIG.DART.Common.MultiBasisLOTSchema.PamMBLotData">
<Item ShortName="James" LongName="James Andy" Number="123456" Code="444" />
</ns0:PamMBLotData>
Now what i have to do is to read the above xml and write it to a flat file in 4 columns
For eg: James to column 1
James Andy to column 2
123456 to column 3
444 to column 4
The above is not in xml format which DataStage can read using xml stages
Could anyone please suggest some solution for this
Thanks in advance