Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

merge multiple comments for a record into one line

jimmys
6 - Meteoroid

I have mutliple comments per record ID like this:

orig.PNG

and I would like to merge them into a single value with line breaks like this:

 new.PNG 

 

How would I do this?

Thank you.

 

 

 

12 REPLIES 12
PaulHo2017
5 - Atom
 
gayvaz004
6 - Meteoroid

Dear Maequee,

 

Thanks for the explanation.

 

When I tried to use your solution, I found out that the '/n' seperator does not work. As you may see from the below ss, in the concat_email column I see /n in text format. However, I want all different e-mails in the new lines. 

 

Could you please help me on this?

 

gayvaz004_0-1643792215473.png

 

gayvaz004
6 - Meteoroid

Dear Maequee,

 

Thanks for the explanation.

 

When I tried to use your solution, I found out that the '/n' separator does not work. As you may see from the below ss, in the concat_email column I see /n in text format. However, I want all different e-mails in the new lines. 

 

Could you please help me on this?

 

gayvaz004_0-1643792215473.png

 

Labels
Top Solution Authors