Discussion Board for collaboration on QlikView Scripting.
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.
LOAD [Profile ID],
(html, codepage is 1252, embedded labels, table is @1);
Left Join (s2)
load CustId, count(CustId) as Cnt Resident s2 group by CustId;
if(Cnt>1, Status1, Status2) as Status,
DROP Table s2;