Solved: Removing Duplicate Values - Qlik Community

qliky88 · ‎2020-10-27

Hi All,

I'm looking to remove duplicate values from a column in an excel file and cannot seem ti figure it out.

Have tried Sunny's method in this post but to no avail.

Any ideas?

QFabian · ‎2020-10-27

Hi, when you create your script adding a excel file, you probably have something like this :

LOAD DISTINCT
F1,
F2
FROM [lib://desktop (user)/excel file.xlsx]
(ooxml, embedded labels, table is [sheet1]);

if you add the DISTINCT, the load will charge only distincts values

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

dplr-rn · ‎2020-10-27

Share more details. your script where you tried and possibly some sample data too

the post you refer to has solution for a simple scenario.

QFabian · ‎2020-10-27

Hi, when you create your script adding a excel file, you probably have something like this :

LOAD DISTINCT
F1,
F2
FROM [lib://desktop (user)/excel file.xlsx]
(ooxml, embedded labels, table is [sheet1]);

if you add the DISTINCT, the load will charge only distincts values

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

Removing Duplicate Values