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.


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


      LOAD ID,

      [First Name],

      [Second Name],

      [Third name]


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


      I will appreciate any help.