topic Lookup between 2 lists in Talend Studio

Lookup between 2 lists

Matt5 — Fri, 15 Nov 2024 23:58:18 GMT

Hi Team,

I'm looking for someone to point me in the right direction. I'm struggling to think up the logic / workflow I need to get the desired output.

I have 2 lists:

List 1:

sku1

sku2

List2:

store1, sku1, 10

store2, sku1, 10

store3, sku1, 2

store3, sku2, 4

store4, sku2, 1

I'm looking for a mechanism that will tell me which store has both skus available.

In the example above, the output would be store3

Thanks.

Re: Lookup between 2 lists

gjeremy1617088143 — Fri, 09 Jul 2021 07:02:07 GMT

Hi if each line is unique : 1store,1sku, 1 value :

you add a new column type Integer value 1 then

you can use for example tAggregateRow component , choose the column wich contain store name as group by and choose the column you add just before with sum option in Operations of taggregateRow.

FInally you have just to compare if the new column have the value of your list 1 row number.

Send me Love and Kudos