One Star

Newbie, component needed for compare two lists

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
6 REPLIES
One Star

Re: Newbie, component needed for compare two lists

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
One Star

Re: Newbie, component needed for compare two lists

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

Re: Newbie, component needed for compare two lists

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

Re: Newbie, component needed for compare two lists

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
One Star

Re: Newbie, component needed for compare two lists

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

Re: Newbie, component needed for compare two lists

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