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