3 Replies Latest reply on Jan 30, 2019 9:12 PM by Zhouyi Zhang

    How to remain single entry & remove duplicate row

    NUR IZZAH ZAKARIA

      I want my final result to remain single entry, & remove those duplicate row, eg: Those that I highlight in yellow, are the rows to be removed.

       

      My data :

      I have tried SQL over partition and filter  only rownumber = 1 but due to my data is huge,  tableau error during refresh extract data. 

       

      select ID, qty, date, row_number() over (partition by ID, order by date) as rownumber from book1.

       

      I have tried Fixed function in Tableau, but since I have group by date, it only remove duplicate entry within same date.

       

      My expected Result : I would like to remain the earlier date for each entry.

       

       

      Could you please advice how to achieve as my expected result  would be appreciated.

       

      Thank you.