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

spr654 — Sat, 16 Nov 2024 00:21:07 GMT

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.

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

David_Beaty — Tue, 30 Mar 2021 14:46:13 GMT

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

topic How to replace variable in file looping another's file values in Talend Studio

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

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