[resolved] How to use Flowtoiterate

[_AnonymousUser]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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

[_AnonymousUser]

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?

[Anonymous]

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

[Anonymous]

My bad. I forgot the .get()

[Anonymous]

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