check the duplicate value

[sagaraperera]

how to filter duplicate value of same claim no. please refer the given below data.

sagara

.

Directory;

CrossTable(DES, BALANCE, 24)

LOAD DATE,

     CLDOR,

     CLNO,

     CLMPRD,

     CLSPRD,

     CLBRCOD,

     CLNAME,

     CLDOL,

     CLDORV,

     CLREAS,

     CLTYP,

     CLFDOP,

     CLTYPA,

     CLTYPF,

     CLTYPR,

     CLVIPCOD,

     CLMECOD,

     CLRECTYP,

     CLSUMI,

     CLFROM,

     CLTO,

     CLCLOS,

     CLRISK,

     MECODE,

     CLTECVAL,

     CLOBAL,

     CLAMTPRO,

     CLFPAID,

     CLADJUS,

     CLBAL,

     CLRECOB,

     CLRECAD,

     CLRECR,

     CLRECBL,

     NOD,

     RFOBAL,

     RFPROV,

     RFRECE,

     RFCBAL

FROM

[..\..\qlickviwe\Claims\CLM_DATA_2014.QVD]

sagara

[avinashelite]

The problem is with the cross()  table , check from which column you need the transformation??