Alteryx Designer Desktop Discussions

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

Need to add , delimiter in Ingredients column data

jassik
8 - Asteroid

Hello Alteryx community , I  have ingredients column where I have different ingredients with different length of characters. How can I split them with comma(,) delimiter.

For eg: my data is--    WATER CORN SYRUP SUGAR MANGO PUREE MANGOES LEMON JUICE 

and I  want my output :   WATER, CORN SYRUP, SUGAR, MANGO PUREE, MANGOES, LEMON JUICE

Can you please help me with it

11 REPLIES 11
caltang
17 - Castor

Yeah this is quite hard to do. Do you have a list of ingredients that you are aware of? Maybe you could map certain words together as part of a group.

caltang
17 - Castor

Once you have the list, an alternative to what the others have mentioned above, you can try this:

 

image.png

Labels