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
Solved! Go to Solution.
Use the Append Fields tool
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.
Thanks @mceleavey , it's perfect.
Quite easy when you know the tool.
Have a nice day!
Best regards,
Axis