Data Parsing

[alteryx_user_9999]

Suppose I have the following strings.

John Doe; Jane Doe; Alice

John Doe, Department of X, United States; IZA, United States; Jane Doe, Department of Y, China; Alice, Department of Physics, United Kingdom

in two separate columns in a dataset. I want to create a new excel file looking like

Names            Names With Affiliation

John Doe        John Does, Department of X, United States

Jane Doe        Jane Doe, Department of Y, United States

Alice                Alice, Department of Physics, United Kingdom

How would I do this in Alteryx? The issue I'm having is that there isn't a 1-1 correspondence between the Names and Names With Affiliation strings if we parse on semi-colon. 

Thank you

[gawa · Accepted solution]

hi @alteryx_user_9999 

Can you try the attached WF?

[alteryx_user_9999]

Thank you so much. I'm going to try it on my bigger dataset, but the logic seems sound to me. Very clever!