Smart Way to Concatenate Columns

[Qiu]

I am wondering if there is a smart way or dynamic way to concatenate String for many columns.
Formula Tool can do the trick if the number column is varying, so the formula needs to be modified each time.
Thanks in advance.

[ChrisTX · Accepted solution]

See this related post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Concatenating-multiple-fields/td-p/608...

[Qiu]

Thank you so much. @ChrisTX