topic Re: tmap display in Talend Studio

tmap display

Anonymous — Sat, 16 Nov 2024 07:22:53 GMT

Hello all.

I have two components - one is a toracleinput which retrieves data from the DB and stores in a thashoutput.

at a later stage, this is called from a thashinput, together a csv file from the file syste. both of these have one field in common.

these are then connected using tmap - problem is here - i would only like to display a final result file showing the values only if there was a match between the two datasets.

i have connected it as per the attached, however in the final csv file, it shows all the data for the entire file. where there is no match, it displays a blank field.

i would like the ones that have no match to not be displayed - can you please assist?

thanks.

Re: tmap display

David_Beaty — Tue, 30 Oct 2018 10:11:51 GMT

What you can do in the tMap is add another output flow, and set the "catch inner join rejects" to true. Then set the join model between row3 & row4 (from your picture) to be an inner join.

Thanks

David

Re: tmap display

Anonymous — Tue, 30 Oct 2018 10:18:17 GMT

Hi david,

thanks for the pointer.

i did this and it worked!!

2018-10-30_11h17_32.png