Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

distinct table from a duplicate field in Qlikview

Hi all,

I want to distinct the table from a duplicate field. The field (ID) has duplicated values , and i want to make it distinct and use that to update the whole table.

Capture.PNG

I want to remove the duplicated ID values and make the table look like this

Capture.PNG

LOAD ID,

[First Name],

[Second Name],

[Third name]

FROM

(ooxml, embedded labels, table is [Events ]);

I will appreciate any help.

Thanks.

0 Replies