Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Make a product of several columns

Axis
7 - Meteor

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

 

FruitYes/No
AppleYes
AppleNo
OrangeNo
AnanasYes
AnanasNo

 

--> I would like to obtain this result :

 

Triple letterFruitYes/No
AAAAppleYes
AAAAppleNo
AAAOrangeNo
AAAAnanasYes
AAAAnanasNo
BBBAppleYes
BBBAppleNo
BBBOrangeNo
BBBAnanasYes
BBBAnanasNo
CCCAppleYes
CCCAppleNo
CCCOrangeNo
CCCAnanasYes
CCCAnanasNo
DDDAppleYes
DDDAppleNo
DDDOrangeNo
DDDAnanasYes
DDDAnanasNo

 

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

4 REPLIES 4
ChrisTX
15 - Aurora

Use the Append Fields tool

 

mceleavey
17 - Castor
17 - Castor

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.

 

mceleavey_0-1614693133836.png

This gives the following output:

mceleavey_1-1614693176153.png

I've attached the workflow for you.

 

M.

 

 



Bulien

Axis
7 - Meteor

Thanks @mceleavey , it's perfect. 
Quite easy when you know the tool. 

 

Have a nice day!

 

Best regards,
Axis

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels