topic Re: How to distinct load a table on multiple fields in QlikView

How to distinct load a table on multiple fields

Anonymous — Mon, 28 Jan 2013 17:04:44 GMT

Hi,

I have a table (lets call it TableA) that looks like this:

ColA ColB ColC

Red 1 A

Red 1 A

Red 1 A

Blue 2 B

Blue 2 B

Black 3 C

Black 3 D

Black 1 D

What I want to do is to get rid of duplicated rows, so to say I want to load this table or convert it into a new table distinct on all three columns so the result ends up like this:

ColA ColB ColC

Red 1 A

Blue 2 B

Black 3 C

Black 3 D

Black 1 D

How do I do this?

BR

Re: How to distinct load a table on multiple fields

shree909 — Mon, 28 Jan 2013 17:07:54 GMT

try this

load

distinct(ColA )

distinct( ColB )

distinct( ColC)

from table ...

Re: How to distinct load a table on multiple fields

alexandros17 — Mon, 28 Jan 2013 17:08:22 GMT

LOAD

Distinct * inline
[

ColA ,    ColB,     ColC

Red     ,    1    ,        A

Red    ,     1     ,        A

Red   ,      1     ,        A

Blue ,       2     ,       B

Blue ,        2     ,       B

Black   ,    3     ,       C

Black ,     3     ,       D

Black   ,    1    ,        D

];

Use "DISTINCT" Keyword