topic Re: Generating multiple excel files based on tFlowToiterate global variable in Talend Studio

Generating multiple excel files based on tFlowToiterate global variable

Anonymous — Mon, 17 Sep 2018 18:29:17 GMT

Hi,

scenario i am doing:

1. I am querying Entity object and putting out put into excel file.

2. I have to go through each and every row in that file with the help of one column called ObjectAPIName. here i i am declaring a tFlowtoiterate to iterate the file and to store ObectAPIName.

3 Each time i query one record and i will get ObectAPIName from file and then I am querying Field definition obect with the help of ObjectAPIName. and then writing it to output file.

so my requirement is

I need to generate different output files for each row which is there in excel 1.

and in file name wht i have to pass

how i can achieve this. ?

Re: Generating multiple excel files based on tFlowToiterate global variable

Anonymous — Tue, 18 Sep 2018 11:03:47 GMT

Hello,

You have to use the value of the iteration : row2.<columnname>.

Regards.

Re: Generating multiple excel files based on tFlowToiterate global variable

Anonymous — Tue, 18 Sep 2018 11:26:25 GMT

@uganesh ,

FileName that you have given is correct , based on your explanation you will get one unique ObectAPIName for every row so , you can use that particular column globalvariable as filename suffix something like "c:/talend/sample"+(string)globalMap.get(row1.ObectAPIName)+".xls" and finally you will get different files for every record like sampleX.xls , sampleY.xls and so on.

Thanks.

Re: Generating multiple excel files based on tFlowToiterate global variable

TRF — Tue, 18 Sep 2018 12:58:32 GMT

@uganesh, the answer I gave you on your other post may help you

https://community.talend.com/t5/Design-and-Development/Putting-tSalesforceInput-out-put-data-row-by-row-into-multiple/m-p/134197#M83626

Re: Generating multiple excel files based on tFlowToiterate global variable

TRF — Tue, 18 Sep 2018 15:36:21 GMT

@uganesh, did this help?

If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).