topic how to create a file from each row with dynamic name based in columns value for each row in Talend Studio

how to create a file from each row with dynamic name based in columns value for each row

oasis2000 — Fri, 15 Nov 2024 22:54:56 GMT

Hi,

I have this flow:

tDBInput - tmap - tflowtoiterate - tfixedinput - tfileoutputdelimited

At the beginning i have a "table" with 3 columns: col1, col2, col3. In the tmap i keep col3 and i create another col (fichName) as col1 + col2. What i want at the end is to have one file for each row and name fichName. Example:

if i had only 1 row in the first table i want to get only 1 file which content is the value of col3 for that only row and the name of that file should be

fichName (

col1 + col2)

I have tried with this flow for a lot of time, also with tsetglobalvar and i dont get the correct result. The closer i got was to have a file for each row containing the value of col3 as desired but the names of those files were null0, null1, null2, etc or simply 0, 1, 2, ...

Can you help me please?

Thanx in advance!

Thanx!

Re: how to create a file from each row with dynamic name based in columns value for each row

Anonymous — Tue, 17 May 2022 21:36:24 GMT

Hi @Beatriz Martinez Serna,

Would you mind showing us your job (a screenshot)? Also include screenshots of your file component's config. It looks like the right flow, I suspect that there is a slight config error. It looks like you are nearly there.

Re: how to create a file from each row with dynamic name based in columns value for each row

Anonymous — Wed, 18 May 2022 07:12:22 GMT

To use the current column value in the file name, the expression looks like below, eg:

"D:/file/"+(String)globalMap.get("out1.fichName")+".txt"

//out1 is the flow name after tMap.

Regards

Shong

Re: how to create a file from each row with dynamic name based in columns value for each row

oasis2000 — Wed, 18 May 2022 08:00:12 GMT

Thanx, I think the problem is in the tFixedFlowInput. I have tried both keeping and not keeping "nombFich" and nothing. Now as i dont really know what i am doing, with the flow as it is, i only get only file again, not one per row as desired :'(

Re: how to create a file from each row with dynamic name based in columns value for each row

oasis2000 — Wed, 18 May 2022 08:01:00 GMT

I tried that, but it didnt work either. Thanx anyway

Re: how to create a file from each row with dynamic name based in columns value for each row

Anonymous — Wed, 18 May 2022 09:28:32 GMT

on tFlowToIterate, use the default the key,value in global variables, in this case, you don't need to use context variable.

Set the file path like:

"D:/file/"+(String)globalMap.get("out1.nomFich")+".csv"

on tFileOutputDelimited, uncheck the 'split the output in several files' box, you have used tFlowToIterate to iterate each row and set a dynamic file name. If you need a sequence id to be added to the file name, you can generate the sequence id on tMap and concatenate it to the file name

Re: how to create a file from each row with dynamic name based in columns value for each row

oasis2000 — Wed, 18 May 2022 10:05:51 GMT

Thanx a lot!! It made the trick!! 🙂