Make a product of several columns

Axis

Hello everyone, 

I'm a bit stuck in my Alteryx development. 

I would like to merge two different table :

1. My KEY

Triple letter

AAA

BBB

CCC

DDD

2. Values for each KEY

Fruit	Yes/No
Apple	Yes
Apple	No
Orange	No
Ananas	Yes
Ananas	No

--> I would like to obtain this result :

Triple letter	Fruit	Yes/No
AAA	Apple	Yes
AAA	Apple	No
AAA	Orange	No
AAA	Ananas	Yes
AAA	Ananas	No
BBB	Apple	Yes
BBB	Apple	No
BBB	Orange	No
BBB	Ananas	Yes
BBB	Ananas	No
CCC	Apple	Yes
CCC	Apple	No
CCC	Orange	No
CCC	Ananas	Yes
CCC	Ananas	No
DDD	Apple	Yes
DDD	Apple	No
DDD	Orange	No
DDD	Ananas	Yes
DDD	Ananas	No

So I would like for each key, to have a row for each values. 

I hope this is understable? 

Thanks a lot for your help. 

Best regards,
Axis

mceleavey

Hi @Axis ,

This is a great example of the dreaded Cartesian join...tread lightly!

Basically, you are appending all values from one input to all values of another.

This gives the following output:

I've attached the workflow for you.

M.

solution.yxmd