Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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=*]
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.