topic Remove duplicates in QlikView

Remove duplicates

Mon, 01 Aug 2011 20:25:38 GMT

How can I remove duplicates values in my database?

Re: Remove duplicates

johnw — Mon, 01 Aug 2011 22:44:19 GMT

That probably depends on what you mean by duplicate values and by removing them. One simple approach for some cases would be this:

SELECT DISTINCT FIELD1, FIELD2, FIELD3, etc.
FROM your database;

Remove duplicates

Tue, 02 Aug 2011 12:05:29 GMT

Hello John, in this example below how can i use this comand select distinct for field Key_Master?

I already tried to do where exists (Key_Master) but with no success.

Intermodal2:

LOAD

Key_Master,

VOYAGE_DESC_2,

VVL_D2,

BOOK_ID,

BL_Number_BDS,

resident Intermodal;

drop table Intermodal;

Rgds,

Remove duplicates

klausskalts — Tue, 02 Aug 2011 13:05:29 GMT

Intermodal2:

LOAD distinct

Key_Master,

VOYAGE_DESC_2,

VVL_D2,

BOOK_ID,

BL_Number_BDS,

resident Intermodal;

drop table Intermodal;