Five Stars

How do i combine rows from same data source after they are splitup?

Capture.PNG

 

I want to combine output of tMap2,tMap4,tMap5 , so that I can write the final output in 1 file. Each of tMap components has comumns A,B,C. I want to combine them by tMap2.A=tMap4.A=tMap5.A && tMap2.B=tMap4.B=tMap5.B and want to keep C of each of the three tMap components.

Any help on how to do this , much appreciated..!

1 REPLY
Twelve Stars TRF
Twelve Stars

Re: How do i combine rows from same data source after they are splitup?

You cannot combine data flows issued from the same source in the subjob where they have been splitted.
Connect each flow to a tHashOutput, then start a new subjob (onSubjobOk) and merge or join the different flows (tHashInput) using a tUnit or a tMap.

TRF