Removing Duplicate Values

[qliky88]

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? 

[dplr-rn]

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 · Accepted solution]

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