Multiple Record Matches across Users

Question

Hey All, long time no see!!

Back to your regular scheduled altering!!

I have a large datasheet of users with their first names and last names.

I want to match every user by last name, but in a mesh.

EXAMPLE: SMITH

Joe Smith
Jane Smith

Fred Smith

Fred joins to Joe and Jane

Jane joins to Joe and Fred

Joe joins to Jane and Fred

I used a multi row to grab matches above and below, which gives me close to what I am looking for:

What I would like to be seeing is this:

Any help on how to get all the matches across multiple rows would be amazing! I can consolidate them into the Source and Target example without a problem!

Thanks so much!!

Jordan

Kenda · Accepted Answer

Hey @JordyMicheal!

I'm not exactly sure how your input looks or how many different last names you'll have, but try the attached workflow, and see if that works for you.

In case there are multiple last names in your input file, I accounted for that in the workflow, so you will see two extra names in the input and output.

Let us know if this works for you! The key is using the Append Fields tool then a Filter.