2 Replies Latest reply: May 23, 2018 3:16 AM by Reynaldson Aceberos RSS

    Remove duplicate and retain the latest items

    Reynaldson Aceberos

      Good day to all i'm having a challenge in my project i hope you can help me,

      I got a 2 qvd file.. please refer to the picture below.

       

      upload 1.JPG

       

      they have a different upload date and price but having the same  item code and ID

      i want to remove the duplicate and retain the latest upload and if the deleted field is 1 then in the final output must be remove.

       

      the steps i did is i combine the 2  QVD file which it looks like this.

       

      concat.JPG

       

      and the final output must be like this

       

      final.JPG

       

       

      thank you in advance to all...

       

      Message was edited by: Reynaldson Aceberos