topic Re: Newbie, component needed for compare two lists in Talend Studio

Newbie, component needed for compare two lists

Anonymous — Sat, 16 Nov 2024 12:27:59 GMT

Hi all,
this is my first try to use Talend Open Studio for Data Integration. I use Version 5.0.1
I have two lists. One contains unsorted EANs. The second one contains EANs which have to be deletet.
Now I want Talend to save all Record containin in Table 1 which are not listet in Table 2 to a third Table.
Datainput an Output like told in the turorial works. But which component is able to do the job?
Thanks for every answer

Re: Newbie, component needed for compare two lists

Anonymous — Wed, 11 Jan 2012 11:01:26 GMT

Hi,
You can use the tMap to join the two inputs. When you configure the lookup to be of type inner join you can configure an output row to catch all "inner join rejects"
This should be the list of EAN's you want to preserve...
Hope this helps!
Oh, and welcome to the Talend community!
Best regards,
Arno

Re: Newbie, component needed for compare two lists

Anonymous — Wed, 11 Jan 2012 11:15:05 GMT

I will try it now. I will answer in my other topic. Submiting the same post a second time was my fault, sorry.

Re: Newbie, component needed for compare two lists

Anonymous — Wed, 11 Jan 2012 11:28:37 GMT

Ok, i´ve got the problem that there is no option to change the "join method".
This is my testproject

And this is the option box of the tMap component

Edit:
The two list containing only a few numbers
List one
EAN SKU
12345 test1
23456 test2
45678 test3
List two
EAN
23456
78907
Key should be the column "EAN". Every EAN of the first list which is not saved in the second list should be copied to a third one.

Re: Newbie, component needed for compare two lists

Anonymous — Wed, 11 Jan 2012 11:39:33 GMT

Hi,
On the "Match model" setting in the tMap you should be able to select "Inner join", but maybe only after you set the expr. key on row2 in the tMap to row1.EAN (it looks like SKU in the picture?)
I've attached a screenshot of how the tmap should look like in my opinion.
Hope this helps!
Regards,
Arno

Re: Newbie, component needed for compare two lists

Anonymous — Wed, 11 Jan 2012 11:57:50 GMT

It works fine. Specifically your picture helped me setting the right options.
Thank you very much.

Re: Newbie, component needed for compare two lists

Anonymous — Wed, 11 Jan 2012 12:07:57 GMT

You're welcome!
Glad it works.
Best regards,
Arno