Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Matrix of all possible combinations from one database output.

Highlighted
5 - Atom

I have a requirement and I have been spinning my wheels for days. I need to create a unique row(s) for all possible possibilities for each person. See below for example.

 

DATA FROM DB

NameEEIDSchoolOfficeFloorCompany
Chase1Harvard   
Chase1 Chicago23 
Chase1   Apple
Chase1   Google
Jerry2Yale   
Jerry2Stanford   
Jerry2 Dallas10 
Jerry2 New York18 
Jerry2   Alteryx
Jerry2   Chick Fil A

 

 

 

Desired Result

NamePIDSchoolOfficeFloorCompany
Chase1HarvardChicago23Apple
Chase1HarvardChicago23Google
Jerry2Yale Dallas10Alteryx
Jerry2Yale Dallas10Chick Fil A
Jerry2YaleNew York18Alteryx
Jerry2YaleNew York18Chick Fil A
Jerry2StanfordDallas10Alteryx
Jerry2StanfordDallas10Chick Fil A
Jerry2StanfordNew York18Alteryx
Jerry2StanfordNew York18Chick Fil A

 

 

 

Any guidance would be greatly appreciated.

 

Thank you in advanced

 

-Chase

Highlighted
Alteryx Partner

This the result that I got. Please verify.

The workflow is attached.

 

Workflow

clipboard_image_0.png

 

 

Result

 

clipboard_image_0.png

Highlighted
Alteryx
Alteryx

Hey @Cwolfle15 ,

 

I got the same result as @hadzramin. Just using the Summarize tool instead of Unique. Great minds think alike. 

 

Matrix.PNG

Highlighted
Alteryx Partner

Cool @NicholasM 

Highlighted
5 - Atom

Thank you so much!! 

Labels