Want to show dedup scenerio or flag - Page 2 - Qlik Community

qliklearnervir · ‎2016-02-26

Hi,

We have availalbe data like this :

Booking ID PersonID Email

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

like if i want unique email than my daa should like

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

Digvijay_Singh · ‎2016-02-29

Like this?

Anonymous · ‎2016-02-29

what you want the actual out put

Digvijay_Singh · ‎2016-02-29

See if this kind of script you can use -

ata:

Load * inline [

Booking ID, PersonID , Email,

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;