Alteryx Designer Cloud Discussions

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

I have some data which in some cells we have commas, I want to create a recipe to: 1- split the string in commas 2- get the last string(after splitting) and replace the cell value with this one.

 
1 REPLY 1
APrasad_Tri
Alteryx Alumni (Retired)

Hi @Admin Data? 

You can achieve this by brushing over the comma as shown below. The suggestions section will give you the option to split the columns with ','.

 

To replace the cell value, brush over the value you want to replace it with the desired value.

 

If you have any further questions, please provide sample data to replicate. Hope this helps.

 

Best,

Apeksha