XML to CSV

Place to post and discuss training related to using open source software.

Moderator: carrier

XML to CSV

Postby sulekha23 » Thu May 19, 2016 7:10 am

I am trying to convert a xml to csv file leads to failure. I tried with XML Input Stream also.
It’s parsing the file but the output is not found to be what I expected.

I was guessing to have header row and all the appropriate values enclosed with the delimiter.

In the XML Input Stream I checked 2 items.

XML Data name and XML Data Value

The file created is having the above two fields. One as Header and the other as xml tags or values as separate rows in that file.
I want the xml elements as the Header and its value appropriately.


My use case will be getting JMS Messages and need to translate it into csv file before loading into the database.
Inserting or Updating JMS messages to database workings fine. But I am trying to put these xml messages transformed into csv in Hadoop to load that hadoop file into the database.

Any help?
sulekha23
 
Posts: 1
Joined: Wed May 18, 2016 1:54 pm

Return to Training

Who is online

Users browsing this forum: No registered users and 1 guest

cron