distinct table from a duplicate field in Qlikview

[Anonymous]

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.

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

LOAD ID,

[First Name],

[Second Name],

[Third name]

FROM

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

I will appreciate any help.

Thanks.