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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
spr654
Creator
Creator

How to replace variable in file looping another's file values

Hi,

I have an xml file where I have 2 variables set in the nodes (address and name). I get the name variable from a csv file that contains 500 rows. The goal is to obtain 500 xml in output, each one with a different name value:

tInputFileDelimited_1 --> tFlowToIterate_1 --> tFixedFlowInput_1 --> tMap_1 --> tFileOutputRaw_1

Î

tFileInputRaw_1

Then, the address file contains only 4 rows. I want to take in input the processed file (tFileOutputRaw_1) and change the address variable with a value from the new csv file, that contains only 4 lines, so I will have to find a method to do this, but at the moment, I didn't find a solution.

Could you assist me with this? The goal is to produce 500 xmls.

Labels (2)
1 Reply
David_Beaty
Specialist
Specialist

Hi,

 

Without see what the tMap is doing, I'd guess that you need to move the tFlowToIterate & tFixedFlowInput to AFTER the tMap.

 

When a flow starts, the filename you're going to output to is evaluated, so if you want 500 files, you need 600 flow to iterates fired.

 

Thanks

 

David