Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Garima2020
Contributor
Contributor

How to store multiple values in a single Qlik Variable?

I have a requirement of storing multiple email addresses of users in a single variable so that the variable can be used in NPrinting Task to distribute the mail. I have data in this format-

Employee_Detail:
load * inline [

EmpId,User,Email_id
1,Garima,'garima.kul@abc.com,gar.kuls@abc.com'
2,Kunal,kunal.dhawan@abc.com
3,Naresh,naresh.kr@abc.com
4,Durgesh,durgesh.pl@abc.com
5,Subodh,subodh.chn@abc.com
6,Sayali,sayali.ra@abc.com

];

so the variable should be able to store multiple addresses against a single user., eg for  EmpId 1 there are 2 email addresses so variable should store both the mail addresses. 

Thanking in anticipation.

Labels (2)
10 Replies
Garima2020
Contributor
Contributor
Author

I totally agree with you. @Lech_Miszkiewicz