Delete duplicates

[maniram23]

leadtype                 product                email               countmail

incomp_teme o      titanum           ravi@gmail.com          2

submitted             visa               krishna@gmail.com    2

complete             personal loan     guru@gmail.com         2

incomp_teme o     personal loan   ravi@gmail.com           2  

submitted             personal loan      guru@gmail.com          2 

incomp_decli           visa                krishna@gmail.com        2

Hi

   Above is sample data.Here based on email need to delete the duplicates.

The output  should be like this.

leadtype                 product                email               countmail

incomp_teme o      titanum           ravi@gmail.com          2

incomp_teme o     personal loan   ravi@gmail.com           2 

submitted             visa               krishna@gmail.com       2

complete             personal loan     guru@gmail.com         2

Condition1:For each email if product is same then in leadtype 6 types or there based on .preority i.e,.

complete/submitted/incomp_time o/incomp_decil/incomp_accep.

condition2:if product is different then no need to delete.

[maniram23]

Here i am attaching sample data.

if no duplicates are there no need to delete.

[Oleg_Troyansky · Accepted solution]

What you need to shoot for is a GROUP BY load with Product and E-mail as key fields and Max(Leadtype) as the aggregation. In order to prioritize your Leadtypes, you can replace their textual names with numbers and add a small table that translates numbers to texts.

cheers,

Oleg Troyansky

Take your Qlik Skills to the next level at the Masters Summit for Qlik - now with new and redesigned materials!