Convert column values into Single value separated by a delimiter

Question

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

Alteryx_clarification.PNG

DawnDuong · Accepted Answer

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

Maskell_Rascal · Accepted Answer

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