Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliky88
Creator
Creator

Removing Duplicate Values

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? 

Labels (4)
1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

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

QFabian

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Specialist II
Specialist II

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

QFabian