topic Re: Delete duplicates in QlikView

Delete duplicates

maniram23 — Fri, 01 Jan 2016 16:23:32 GMT

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

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.

Re: Delete duplicates

maniram23 — Fri, 01 Jan 2016 16:28:13 GMT

Here i am attaching sample data.

if no duplicates are there no need to delete.

Re: Delete duplicates

Oleg_Troyansky — Fri, 01 Jan 2016 16:37:00 GMT

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!