topic Re: duplicate removal in QlikView

duplicate removal

qliklearnervir — Tue, 29 Sep 2015 13:17:31 GMT

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.

MK_QSL — Tue, 29 Sep 2015 13:22:24 GMT

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 — Tue, 29 Sep 2015 13:26:23 GMT

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;