topic From tAggregateRow to tMap in Talend Studio

From tAggregateRow to tMap

Anonymous — Sat, 16 Nov 2024 12:22:59 GMT

Hi,
How can I use the data from an output of tAgreggateRow to tMap? I can't join this two components.
I also tried with tFilterRow and can't join it with tMap either.
Thanks in advance,
Khor

Re: From tAggregateRow to tMap

Anonymous — Tue, 14 Feb 2012 08:54:41 GMT

Hi Khor
Wierd.
Close TOS and restart it.
Can you link tAggreggateRow or tFilterRow with tMap this time?
Regards,
Pedro

Re: From tAggregateRow to tMap

Anonymous — Tue, 14 Feb 2012 09:02:43 GMT

Hi pedro,
Still not working, here's a screenshot of the job to help you figure it out.
Thanks,
Khor

Re: From tAggregateRow to tMap

Anonymous — Tue, 14 Feb 2012 09:07:13 GMT

Hi Khor
Got it.
The reason is that in talend you can't create a job with any loop(circle).
tMap(181) -> tAgreggateRow ->tMap_5
| |
----------------------------------
It's a circle, which is forbidden.
Regards,
Pedro

Re: From tAggregateRow to tMap

Anonymous — Tue, 14 Feb 2012 09:10:42 GMT

Hi pedro
Thank you for the tip, how should I do it then?

Re: From tAggregateRow to tMap

Anonymous — Tue, 14 Feb 2012 09:14:48 GMT

Hi
I'm afraid you have to save the temp data into a file.
Then create a subjob with "OnSubjobOk" to load data from it.
Or you can use tHashOutput and tHashInput which save temp data into memory.
But these components will have a bad effect on performance.
Regards,
Pedro

Re: From tAggregateRow to tMap

Anonymous — Tue, 14 Feb 2012 11:12:45 GMT

Hi pedro,
Many thanks for your help.
Regards,
Khor