Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Splitting comma separated values in a field into multiple rows

Highlighted
7 - Meteor

Hi all!

 

Hoping someone can help.

 

Please see below sample data:

 

DrinkCard or CashPrice
Coffee, Tea, CokeCard80p
CoffeeCash80p
CoffeeCard80p
Tea, CokeCard80p

 

I want to separate out the comma separated values into separate rows but keep the data in all other columns. I would want the above to look like the below:

 

DrinkCard or CashPrice
CoffeeCard80p
TeaCard80p
CokeCard80p
CoffeeCash80p
CoffeeCard80p
TeaCard80p
CokeCard80p

 

What is the best way to do this please?

 

Please note also within the same data set have the same issue where some values are separated by '/'

 

Thanks so much!

Alteryx Partner

Hi @ccostello 

 

Use the text to columns tool but select "split to rows"

 

Blake_0-1581693695997.png

 

Although my screenshot doesn't show it, you can toss both delimiters in the tool. 

 

See the attached example and please mark this as solved if it accomplishes what you are trying to do.

Highlighted
7 - Meteor

Thanks so much that was so quick and easy! Fixed my issue- appreciate it

Labels