Comparing multiple values from 2 columns

Dilver_Shaik

Hi Team, need help with below scenario how to get in Alteryx. Below is my source data

Branch ID	Head ID	Branch	Head
12345	67890	Mexico, Columbia, Delhi, Paris	Columbia, Paris, Rome, Italy, New York
09576	12658	Srinagar, Chennai, Hyderabad	Hyderabad, Chennai, Mumbai, Pune

Expected Output is to display the values that are in Branch and not in Head i.e., Mexico & Delhi for the first row.

Branch ID	Head ID	Branch	Head	Difference
12345	67890	Mexico, Columbia, Delhi, Paris	Columbia, Paris, Rome, Italy, New York	Mexico, Delhi
09576	12658	Srinagar, Chennai, Hyderabad	Hyderabad, Chennai, Mumbai, Pune	Srinagar

Any help is much appreciated.

Thanks & Regards

Dilver

DataNath

Here's one way you could go about this @Dilver_Shaik. This approach:

1 - Splits out all of the branches into their own rows

2 - Filters out records where either field is empty (useless comparison) and then also those where head contains branch

3 - Summarizes to re-concatenate the remaining 'Branch' as [Difference]

4 - Re-joins to the main dataset for the original Branch details

Check for Branch not in Head.yxmd