Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Remove duplicates

How can I remove duplicates values in my database?

1 Solution

Accepted Solutions
MVP
MVP

Re: Remove duplicates

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;

View solution in original post

3 Replies
MVP
MVP

Re: Remove duplicates

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;

View solution in original post

Not applicable

Remove duplicates

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,

Highlighted
Partner
Partner

Remove duplicates

Intermodal2:

LOAD distinct

  Key_Master,

  VOYAGE_DESC_2,

  VVL_D2,

  BOOK_ID,

  BL_Number_BDS,

resident Intermodal;

drop table Intermodal;