topic Re: Handling duplicate customers in QlikView

Handling duplicate customers

Sun, 13 Dec 2015 16:10:52 GMT

The above table has duplicate customer(200) and two unique customers(100 & 300).

For Duplicates customer the Status would be taken as Status1

For Unique customers the Status would be taken as Status2.

Please help me to get the below mentioned result.

maxgro — Sun, 13 Dec 2015 17:16:46 GMT

s2:

LOAD [Profile ID],

Status1,

Status2,

CustId

FROM

(html, codepage is 1252, embedded labels, table is @1);

Left Join (s2)

load CustId, count(CustId) as Cnt Resident s2 group by CustId;

final:

LOAD

[Profile ID],

if(Cnt>1, Status1, Status2) as Status,

// Status1,

// Status2,

CustId

Resident s2;

DROP Table s2;