topic TMap: how to perform lookup with composite key and insert based on that complex key in Talend Studio

TMap: how to perform lookup with composite key and insert based on that complex key

anna_t1 — Sat, 16 Nov 2024 00:15:01 GMT

I have a simple table and I want to insert if:

1) a certain id doesn't exist

2) if that id exists, but one+ of the 3 remaining fields are different

How can I achieve this logic with tMap? I spent too much time around this and with many possibilities, but either I get all with "Y" flag for insert, or I just "Y" for insert when a new id is not there. Am I missing something? I can't find any example for this. Note: No updated is needed, just insert when (c1,c2,c3,c4) is not on target.

Re: TMap: how to perform lookup with composite key and insert based on that complex key

ThWabi — Mon, 19 Apr 2021 05:57:08 GMT

Hello anna_t,

I suggest using an Inner Join on the input side on the left. On the output side, the first output panel is an Inner Join Reject, the second one is for catching those rows where the other fields differ.

Best Regards,

Thomas

Re: TMap: how to perform lookup with composite key and insert based on that complex key

gjeremy1617088143 — Mon, 19 Apr 2021 06:53:44 GMT

Hi, you could achieve this in two time, first : inner join with the first id and get the result of the inner join, second : inner join with the three values and get the reject of the inner join.

Send me Love and Kudos