Convert column values into Single value separated by a delimiter

[vshekharrc]

Hi team,

Greetings of the day!

Please see attached. I want input which has field values to be converted into output as shown in the file with _ as delimiter. How can I do this in alteryx. Are there built in functions like to perform this ? Should I use multi row formula tool. I did not understand. Kindly help and advise.

Regards

Varun Shekhar

[DawnDuong · Accepted solution]

Hi @vshekharrc 

yes there is. Connect a “Summarize” tool to your input, set the method to “Concatenate” and the delimeter to be the underscore.

cheers

dawn 

[vshekharrc]

Hi All,

Also please seem my workflow that I have prepared. Are there any better alternatives for this, I would like to learn.

Regards

Varun Shekhar

[Maskell_Rascal · Accepted solution]

Hey @vshekharrc - you don't need the Formula Tool to replace the comma for an underscore. You can set the delimiter in the Summarize Tool as @DawnDuong suggested. 

Cheers!

Phil

[vshekharrc]

Got it, I had noticed that earlier. Thanks to both of you @Maskell_Rascal  and @DawnDuong ! Have a good day 🙂

Regards

Varun Shekhar