Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Generate n XMLs from CSV with n rows

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.
0683p000009MGuL.png

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello,

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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

Hello,

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