Case 886 How to detect duplicate email ?

[paulyeo11]

Hi All

I have load a mailing list into Qlik View as below , from the email listing table (A) below :-

Table (A) Email Listing :-

CONTACTID..............................Email
zcrm_4325140000000415821 0rts@stee.stengg.com
zcrm_4325140000000394899 a.hong.my@sg.azbil.com
zcrm_4325140000000394902 a.koh.hk@sg.azbil.com
zcrm_4325140000000405882 catherine@mattenplant.com.sg
zcrm_4325140000000405884 catherine@mattenplant.com.sg

Remark :- Each CONTACTID is unique number.

May i know how to create a expression , So that it will flag those duplication contact ?

CONTACTID..............................Email
zcrm_4325140000000405882 catherine@mattenplant.com.sg
zcrm_4325140000000405884 catherine@mattenplant.com.sg

I try to search for solution from this forum , unable find one suit above.

Paul Yeo

[Miguel_Angel_Baeyens]

EXISTS() in the script will do exactly what you are looking for:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Inter...

Note: you posted in the Qlik Sense section, it would help if you post in the appropriate product section.

[paulyeo11]

Hi Sir

Sorry I post on wrong forum.

Paul

[Saravanan_Desingh · Accepted solution]

One solution is.

tab1:
LOAD * INLINE [
    CONTACTID,Email
    zcrm_4325140000000415821,0rts@stee.stengg.com
    zcrm_4325140000000394899,a.hong.my@sg.azbil.com
    zcrm_4325140000000394902,a.koh.hk@sg.azbil.com
    zcrm_4325140000000405882,catherine@mattenplant.com.sg
    zcrm_4325140000000405884,catherine@mattenplant.com.sg
];

Left Join(tab1)
LOAD Email, If(Count(Email)>1, 'Y', 'N') As Flag
Resident tab1
Group By Email;

[Saravanan_Desingh]

[paulyeo11]

Hi Sara

Your load script work fine. it save me a lot of time.

Paul 

[Saravanan_Desingh]

you welcome