topic Re: Splitting the values from tmap bases on filter and joining it back in Talend Studio

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

j_ — Fri, 15 Nov 2024 23:14:08 GMT

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 ...

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

gjeremy1617088143 — Tue, 08 Feb 2022 15:36:16 GMT

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

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

j_ — Wed, 09 Feb 2022 10:28:52 GMT

Thank you 🙂 Its working fine with thash input