We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Joining two data sets and combining rows

rallij
5 - Atom

Hello!

 

I'm trying to identify how to reconcile two data sets with similar data for a final list to capture list of owners, # of states in which they operate, # of locations they operate, and state filter capability which will tell me which locations they operate in the respective state.

 

rallij_0-1683664177216.pngrallij_1-1683664197057.png

rallij_3-1683664408376.png

 

 

1 REPLY 1
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @rallij ,

 

Here is one way of doing this.

To test the field "Excluded from Data Set 2", I added a row in Data set 1.

Others should be the same as your data.

Please let me know if you find any issues.

 

Workflow

Yoshiro_Fujimori_0-1683669045441.png

 

Output

Yoshiro_Fujimori_1-1683669068577.png

 

Labels
Top Solution Authors