Cross Tables Duplicates Removal

[abhaysingh]

HI all,

i made a cross table in Which i have combine 6 column into one field which is my AGeing column.. now my Ageing values Frequency is increased.. how can i remove Duplicates from them.

regards

Abhay

[#2]

try This:

use Distinct to remove duplicates

ex:

Tablename:

LOAD  Distinct 

     oneField

FROM

[..\QVD\Raw QVD\Tablename.qvd]

(qvd);

[sunny_talwar]

May be try a resident load from your previous table and use a group by statement with the FirstValue function which will give you the first instance of the repetition.

Best,

Sunny

[Anonymous]

hi,

you must add a DISTINCT just after your LOAD, so that you load only different lines