[resolved] Generate n XMLs from CSV with n rows

Anonymous — Tue, 17 Nov 2015 06:22:58 GMT

How can I make a job iterate such that I can generate 1 XML output file per input CSV row? My job is currently as shown:

tFileList --(iterate)-- tFileInputDelimited --(row)-- tXMLMap --(row)-- tFileOutputXML

[list=*]

tFileList - get all CSVs in source folder

tFileInputDelimited - get CSV as input one at a time

tXMLMap - transform data into XML mapping

tFileOutputXML - generate XML

Whenever I try to remove the limit inside the tFileInputDelimited (currently limited to 1 row), it only generates 1 XML file with n loops based on the n rows of the CSV. Thus right now, at limit 1, it generates 1 XML file with 1 loop of CSV row data.

EDIT: PROBLEM HAS BEEN SOLVED

Solution was to click the wrench icon at the top right of the xml mapping window, then under "All in one" set it to "false". This was actually the default setting and my workmate changed it to "true" before giving it for me to continue with. Now it generates 1 XML file per CSV row read. Screenshot included.

Re: [resolved] Generate n XMLs from CSV with n rows

Anonymous — Wed, 18 Nov 2015 04:18:26 GMT

Hi junmilsso,
We see this topic has been marked as resolved. Could you please share your solution with us?
Best regards
Sabrina

Re: [resolved] Generate n XMLs from CSV with n rows

Anonymous — Wed, 18 Nov 2015 06:41:48 GMT

Hello,

Sorry for the lack of update, edited to show solution now.

topic [resolved] Generate n XMLs from CSV with n rows in Talend Studio

[resolved] Generate n XMLs from CSV with n rows

Re: [resolved] Generate n XMLs from CSV with n rows

Re: [resolved] Generate n XMLs from CSV with n rows