ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

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.