N to N matching (1 to N loop ?)

SaoriYamguchi

Hi, I use Alteryx every day 

So,I want to match the two table.

Table A

USERID request1  request2  request3

U1            AA           12             aaa

U1            BB           23             bbb

U2            AA           Null           ccc

U3　   　 Null         22             aaa

 

TableB

ITEMID  request1  request2  request3

IT1           AA           23            ccc

IT1          AA           22             ccc

IT2         AA             12            aaa

IT2         BB            22             aaa

IT3         CC           12            aaa

 

TableC （matching result）

USERID ITEMID

U3　      IT3

U1         IT2  

So,TableA and TableB's request name are  same meaning.

And, ITEMID and USERID's want condition are multiple.

And,ITEMID and USERID's want condition are "Null" that means "Wildcard"(All matching)

I want to resolve the problem.

But,This problem is too compex.

I think that I use macro, but this problem is very complexity.

Thank you for your kindness.

　

mceleavey

Hi @SaoriYamguchi,

The UserID is not being used in the join, so it wouldn't matter if it was populated or not.

The joins would be made on the combination of the requests only.