Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The problem is with the cross() table , check from which column you need the transformation??