Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Concatenate 2 or more column

Khanzali007
8 - Asteroid

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.

5 REPLIES 5
Luke_C
17 - Castor

Hi @Khanzali007 

 

Here's how I'd do it:

  1. Transpose data
  2. Filter empty records
  3. Concatenate data
  4. Join concatenated comments back to dataset

 

Luke_C_0-1656009030124.png

 

Khanzali007
8 - Asteroid

That's, really quick reply, appreciated 

Thank you, It works.

Khanzali007
8 - Asteroid

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.

Kurohits
10 - Fireball

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. 

 

Kurohits_0-1656057370171.png

 

Khanzali007
8 - Asteroid

Thank you @Kurohits 

Labels