topic Re: Cross Tables Duplicates Removal in QlikView

Cross Tables Duplicates Removal

abhaysingh — Tue, 28 Apr 2015 09:24:42 GMT

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

Re: Cross Tables Duplicates Removal

Tue, 28 Apr 2015 10:01:28 GMT

try This:

use Distinct to remove duplicates

ex:

Tablename:

LOAD Distinct

oneField

FROM

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

(qvd);

Re: Cross Tables Duplicates Removal

sunny_talwar — Tue, 28 Apr 2015 10:06:42 GMT

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

Re: Cross Tables Duplicates Removal

Anonymous — Thu, 20 Sep 2018 15:34:37 GMT

hi,

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