Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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