Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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