Lookup between 2 lists

[Matt5]

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.

M

[gjeremy1617088143]

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