topic Re: CSV to Multiple xml file conversion in Talend Studio

CSV to Multiple xml file conversion

Anonymous — Sat, 16 Nov 2024 14:23:56 GMT

Hi,
I want to convert csv file to multiple xml file based on the record value, TAdvancedFileOutputXML component convert the entire csv to one xml.
How to create multiple xml based on values.
thanks a lot.

Re: CSV to Multiple xml file conversion

Anonymous — Mon, 14 Apr 2008 03:00:01 GMT

Hello
Can you show some input data and what are you expected result?
Best regards
shong

Re: CSV to Multiple xml file conversion

Anonymous — Mon, 14 Apr 2008 04:14:35 GMT

Hi Shong,
i have a csv file with 4 columns named
Country city name age
Singapore shong test 23
Singapore shong test1 15
Hongkong xxxx velu 32
like this 1000 of rows.
I have to read this file and create a xml based on the country
those who all belong to same country and city(Singapore and shong ) are to be written in to one file.
then the next country to another file, and so on.
Thanks and Regards
Velu

Re: CSV to Multiple xml file conversion

Anonymous — Tue, 15 Apr 2008 10:33:37 GMT

Hello Velu
Here comes a Java example: (please see the screenshot)
tFileInputDelimited_1=tFileInputDelimited_3:

USA;New work;Elise;36
China;Shenzhen;shong;26
France;Paris;Plegall;27
Britain;London;Alice;23
France;Lyon;Alan;34
China;Beijing;TangYi;22
France;Nantes;Tom;44
China;Beijing;Yitong;20
France;Toulouse;CCarbone;30
Britain;London;Edward;23

tFileOutputDelimited_1=tFileInputDelimited_2;
Hope it helps you!
Best regards
shong

Re: CSV to Multiple xml file conversion

Anonymous — Wed, 11 Feb 2009 11:23:33 GMT

Hi Shong,
i tried to create multiple XML file from DB, but end up with one file. when a particular field changed , need to create another file. Please help to create the same.thanks

Re: CSV to Multiple xml file conversion

Anonymous — Thu, 12 Feb 2009 09:04:25 GMT

Did you test shongs's solution?
Looks like this will work and fit you needs (creating different files based on a value in your row).
Setting the (dynamic) filename is made in picture "outschema2.png".
Bye
Volker

Re: CSV to Multiple xml file conversion

_AnonymousUser — Mon, 29 Jul 2013 10:16:17 GMT

Thanks Shong.
I was looking for a comparable solution in Talend (for informatica , similar scenario) and this solution works perfectlt fine for me.