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

Matrix of all possible combinations from one database output.

Cwolfle15
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

4 REPLIES 4
Hadzramin_Rahman
8 - Asteroid

This the result that I got. Please verify.

The workflow is attached.

 

Workflow

clipboard_image_0.png

 

 

Result

 

clipboard_image_0.png

NicholasM
Alteryx Alumni (Retired)

Hey @Cwolfle15 ,

 

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

 

Matrix.PNG

Hadzramin_Rahman
8 - Asteroid

Cool @NicholasM 

Cwolfle15
5 - Atom

Thank you so much!! 

Labels