How to Concatenate 2 or more column into one with ampersand (&) where ever there are more than 1 comment/remarks.
Refer column A to I (Input data)
Refer last column J - which is expected the result from Alteryx.
Also check upon the column J highlighted with yellow color, where 2 comment are concatenate with ampersand (&).
Thanks in advance.
Solved! Go to Solution.
Hi @Khanzali007
Here's how I'd do it:
That's, really quick reply, appreciated
Thank you, It works.
Hi @Luke_C I have one question posted, but not answered till now, can you please help me out. I will mark you there, so you can get notified with that post.
Hi @Khanzali007
I know I am bit late for this post but just wanted to share another method of doing this. Attached workflow also for you reference.
Thank you @Kurohits