Splitting the values from tmap bases on filter and joining it back

[j_]

Hi ,

I have a Talend job in which the data is fetched from the database and file and records are inner joined.Then i filter out the records in the tmap in 3 conditions ...if rank = 1 then go to file 1 .If rank=2 go to file 2 .If rank-3 go to file 3 .

Now i have to join file 1 and file 2 by joining some 5 different fields and then fetch the reject record by merging the file 1 and file2 and save this in file 4 ..

Similarly i have to join file 4 with file 3 by joining and taking the rejected record and merge the records ..

AM not sure how to accomplish this since talend will not allow joining the records after splitting it ...

[gjeremy1617088143 · Accepted solution]

hi , you can use tHashInput and tHashOutput component to fill a hash with splitted row, hash component allow you to write in the same hash or different hash. to activate them you have to go to the project properties, then designer and in the technical folder you have to drag them from hide to show panel.

https://help.talend.com/r/en-US/7.2/technical/thashinput

https://help.talend.com/r/en-US/7.2/technical/thashoutput

Send me love and kudos

[j_]

Thank you 🙂 Its working fine with thash input