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