Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
slondono
Partner - Creator II
Partner - Creator II

Concatenate all Possible field values in one row.

Hi guys

I need to concatenate the possible field values in a table. The field is e-mail (its for an nprinting thing).

email.PNG

so, i need a table with this possible fields concatenated, something like this: 95david@hotmail.es;120@hotmail.com;123@hotmail.com

Im doing this because i need that NPrinting send just 1 email to all people and not 1 email per person.

1 Solution

Accepted Solutions
sunny_talwar

Can you try this:

Concat(DISTINCT Correo, ';')

View solution in original post

3 Replies
sunny_talwar

Can you try this:

Concat(DISTINCT Correo, ';')

slondono
Partner - Creator II
Partner - Creator II
Author

Excelent, save my life

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Note that siooner or later, some MTA has to duplicate the message and send a copy to each individual user. You just don't like NPrinting doing this?