0 Replies Latest reply: May 18, 2018 9:38 AM by ibrahim oladipo RSS

    distinct table from a duplicate field in Qlikview

    ibrahim oladipo

      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

      [C:\Users\OneDrive\ Events.xlsx] (ooxml, embedded labels, table is [Events ]);

       

      I will appreciate any help.

       

      Thanks.