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

    How to remain single entry & remove duplicate row


      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.