Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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.
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
Output
