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
