Duplication remove with aggr

dhanu_today — Tue, 10 Dec 2013 18:50:56 GMT

Hi All,

I have the req as per below sample data.

If 1 srm contains unique custid(e.g. 800) then count should be 1 and if the same srm contains the multilple custid's(e.g 1000 and 1000) then we have to show 1 or 0.

If one custid(e.g 4000) contains multiple srm's(e.g 2000 and 3000) then we have to remove that records.

load * inline

[

acctno,srm,custid Count

1000,900,800----------------------------------------1

1001,900,1000---------------------------------------1 or 0

1002,900,1000----------------------------------------0 or 1

1003,900,5000----------------------------------------1 or 0

1004,900,5000-----------------------------------------0 or 1

1009,2000,4000----------------------------------------I have to remove this record

1010,3000,4000----------------------------------------I have to remove this record

]

Please find the attachment which i have tried.

I need some help at 'removing of reocrd level'

Thanks in advance,

Dhanu

topic Duplication remove with aggr in QlikView

Duplication remove with aggr