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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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