topic Create Distribution List from Table in QlikView

Create Distribution List from Table

pkelly — Wed, 25 May 2011 10:55:25 GMT

Hi...

I have a table (EmployeeMaster) which has the following field "emp_EmailAddress".

As the name suggests, this is an employee table.

I want to create a variable called "emailTo" which will be populated which each of the email addresses in the table seperated by a ";".

For example...

If the table contained joe.bloggs@here.com and jim.bloggs@there.com, I would end up with a variable that looks like...

I will be using this to populate the to field in an e-mail....

Thanks in adavance for any help on this...

Paul

Wed, 25 May 2011 11:21:38 GMT

Hi,

Use Concat function for SQL:

SQL select concat(emp_EmailAddress, '; ') from EmployeeMaster

pat_agen — Wed, 25 May 2011 11:28:52 GMT

hi,

alternatively if you have already loaded your EmployeeMaster into a qvw then the following varaible will get you your list:

let vListEmails='=concat(emailTo,' & chr(039) & ';' & chr(039) & ')';