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. ?
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.
@Lavankumar, the answer I gave you on your other post may help you
@Lavankumar, did this help?
If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.