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