Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

idoladipo
New 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.