Generating multiple excel files based on tFlowToiterate global variable

[Anonymous]

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. ?

[Anonymous]

Hello,

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

Regards.

[Anonymous]

@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.

[TRF]

@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-...

[TRF]

@uganesh, did this help?

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