One Star

From tAggregateRow to tMap

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
6 REPLIES
One Star

Re: From tAggregateRow to tMap

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

Re: From tAggregateRow to tMap

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

Re: From tAggregateRow to tMap

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
One Star

Re: From tAggregateRow to tMap

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

Re: From tAggregateRow to tMap

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
One Star

Re: From tAggregateRow to tMap

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