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?
SystemAdmin 110000D4XK6184 Posts
Re: csv to xml2012-12-07T11:27:03ZThis is the accepted answer. This is the accepted answer.If 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 0700000S5J655 Posts
Re: csv to xml2012-12-07T12:02:24ZThis is the accepted answer. This is the accepted answer.As 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.