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: 
qliklearnervir
Creator
Creator

Want to show dedup scenerio or flag

Hi,

We have availalbe data like this :

Booking ID      PersonID                  Email

B01                 P01                           ABC@mail.com

B02                 P02                          XYZ@mail.com

B03                 P01                           ABC@MAIL.COM

B04                 P01                          ABC@mail.com

B05                  P02                        XYZ@mail.com

Now as per scenerio , i dont to miss any data ....

like   if i want unique email than my daa should like

ABC@mail.com

XYZ@mail.com

But i want all the Booking ids....not like max of email and limited ids...

same for person id ......if i can say i   want  unique person than in straight table i want all booking ids and email.......kindly suggest

12 Replies
Digvijay_Singh

Like this?

Anonymous
Not applicable

what you want the actual out put

Digvijay_Singh

See if this kind of script you can use -

ata:

Load * inline [

Booking ID,      PersonID  ,                Email,

B01,                 P01   ,                        ABC@mail.com

B02,                 P02  ,                        XYZ@mail.com

B03 ,                P01  ,                         ABC@MAIL.COM

B04 ,                P01  ,                        ABC@mail.com

B05 ,                 P02 ,                       XYZ@mail.com  ];

Temp:

Load

  PersonID,

  Count([Booking ID]) as BookingCount,

  Concat(Email,',') as Email

Resident Data

  Group By PersonID;

Drop Table Data;