Conditionally append fields

[ew87]

I have a scenario where I have two columns that contain names (we'll call them column A and column B). I only want the names from Column B if the name doesn't already exist in Column A. Then, I want to take any unique names from Column B and append them as new rows in Column A. It's okay if any other columns associated are null with the append.

Any ideas?

[adamorse · Accepted solution]

What you can do is as join on Left_Column A = Right_Column B. The right output of this join will have all values in Column B that don't appear in Column A. You can then do a union to get those unique Column B values as new rows.

[afv2688 · Accepted solution]

Here's a workflow example.

Take care with this, joins are case sensitive. Therefore 'Charles' and 'charles' would be 2 different names. I recommend you to add first an uppercase formula or a lowercase one.

[ew87]

Worked like a charm. Thank you!

[ew87]

The workflow was incredibly helpful. Thank you very much :)