hello, I have a csv file muk.csv. I want to convert the input values in the csv file to an xml file. I don't know how to interpret the headesr s in the csv file, I mean i just want the values to be mapped and not the headers. The header names come as an output in the generated xml file. So if I have the following input: Name,Id,TotalRec
Expected output: <Id>Muks</Id>
what i am getting is something like this: <Id>Name</Id>
<transID>2</transId>.......ans so on
So basically it is treating header names as input. I just want the values. Can anyone help me on this please?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2012-12-10T13:41:17Z by Muk1234
Pinned topic csv to xml
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-10T13:41:17Z at 2012-12-10T13:41:17Z by Muk1234
SystemAdmin 110000D4XK6184 PostsACCEPTED ANSWER
Re: csv to xml2012-12-07T11:27:03Z in response to Muk1234If you can't get rid of the headers, the solution would be to ignore them either via the type tree (which means creating a specific group for the headers) or only process from the second one (using EXTRACT to select what you pass to the fmap)
paul.brett 0700000S5J452 PostsACCEPTED ANSWER
Re: csv to xml2012-12-07T12:02:24Z in response to Muk1234As a follow-up to Laurent's suggestion, as you don't need to map the header row, just define it as a text blob with a terminator of whatever is currently your row delimiter (I assume a <NL> character).
You're not mapping this data, so you can chuck it all into a very simple Typetree object for greater mapping speed.