Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qliklearnervir
New Contributor III

duplicate removal

Hi,

we have some data  like below;

ID  Email

1   abc.email.com

2   abc.email.com

3    xyz.email.com

data having duplicate emailids, that i want to remove....kindly suggest the possible ways in script.

Tags (1)
2 Replies
MVP
MVP

Re: duplicate removal

temp:

Load * Inline

[

  ID,  Email

  1,   abc.email.com

  2,   abc.email.com

  3,   xyz.email.com

];

Left Join(temp)

Load ID, Email, if(Email=Previous(Email),1,0) as Flag Resident temp

order by ID;

NoConcatenate

Final:

Load ID, Email Resident temp

Where Flag = 0;

Drop Table temp;

Digvijay_Singh
Honored Contributor III

Re: duplicate removal

table:

load * inline [

ID,  Email

1,   abc.email.com

2,   abc.email.com

3 ,   xyz.email.com ];

NoConcatenate

Load min(ID) as ID, Email resident table group by Email;

drop table table;

Community Browser