Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Creating Rows Based on Dynamically Parsed Field

8 - Asteroid

I have a template we use to determine how to filter HR data.  The business wants to be able to dynamically exclude certain companies based on a value called MRC. 


Please find attached the template we are using.  Column J is the one I would like to parse out and then based on how many new fields get created, a new row would be created that includes all of the other data on the same row but would include one of the MRC values. So if there are 3 values in column J 3 new rows would be created with all of the other info.  if there are 2 - two new rows.. etc. 


I assume this is possible with some type of dynamic formula tool or another method? 

11 - Bolide

I suggest trying text to columns in combination with the transpose tool to change the parsed columns to rows and then joining it back to your data set on job function.