topic Re: [resolved] How to use Flowtoiterate in Talend Studio

[resolved] How to use Flowtoiterate

_AnonymousUser — Sat, 16 Nov 2024 14:02:23 GMT

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

Re: [resolved] How to use Flowtoiterate

Anonymous — Mon, 16 Mar 2009 03:41:51 GMT

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

Re: [resolved] How to use Flowtoiterate

Anonymous — Mon, 16 Mar 2009 14:11:08 GMT

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

Re: [resolved] How to use Flowtoiterate

_AnonymousUser — Mon, 17 Aug 2009 17:21:24 GMT

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?

Re: [resolved] How to use Flowtoiterate

Anonymous — Mon, 17 Aug 2009 17:26:50 GMT

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

Re: [resolved] How to use Flowtoiterate

Anonymous — Mon, 17 Aug 2009 17:48:01 GMT

My bad. I forgot the .get()

Re: [resolved] How to use Flowtoiterate

Anonymous — Tue, 17 Nov 2009 08:24:41 GMT

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