Joining two data sets and combining rows

rallij

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.

Yoshiro_Fujimori

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

Join_Concatenate.yxmd