One Star

[resolved] How to use Flowtoiterate

Hi,
I would like to know How can use either FLowtoiterate or any other component to output different files for different records.
(I am using oracleinput and a query to get the data and then parse out the message and putting the parsed data into excel file)
How can I output different files for different records ?.
Thanks,
Milind
1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

Re: [resolved] How to use Flowtoiterate

Hello Milind
Here is an example of showing how to use tFlowToIterate component and output each record to different file.
Input file:
1;shong
2;elise
3;mhirt

Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
6 REPLIES
Community Manager

Re: [resolved] How to use Flowtoiterate

Hello Milind
Here is an example of showing how to use tFlowToIterate component and output each record to different file.
Input file:
1;shong
2;elise
3;mhirt

Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] How to use Flowtoiterate

Thanks a lot for such a quick and detailed response !
Milind
One Star

Re: [resolved] How to use Flowtoiterate

Hi, when following the example here, I receive an exception:
- "The method globalMap(string) is undefined for the type iterate_test" where iterate_test is my job name.
Any thoughts?
One Star

Re: [resolved] How to use Flowtoiterate

Registered an account now. I forgot to mention, working on Java and coming from SybaseDb.
One Star

Re: [resolved] How to use Flowtoiterate

My bad. I forgot the .get()
One Star

Re: [resolved] How to use Flowtoiterate

Hello!
Thanks for the procedure. If you replace the tFileOutputDelimited by a tFileOutputMSXML, it doesn't work: only one file is created because globalMap.get("row1.<my column name>") returns null, so all the elements are in the same XML file.
globalMap.get("row1.<my column name>") is a checked expression because it works with tAdvancedFileOutputXML and tFileOutputDelimited .
Seems to be a bug isn't it?
Regards