2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
16 - Nebula

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
9 - Comet

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