2 Replies Latest reply: Nov 21, 2013 1:38 PM by Zach Paz RSS

    Removing Duplicates based on Date and Time Stamp

    Zach Paz

      I am trying to load only the most recent records based on date and time stamp.

       

      I have one QVD with the following records:

       

      lead_id

      status_name_update

      status_date_update

       

      There are multiple status names with a date and time stamp for each lead_id. Example:

       

      lead_id  status_name_update  status_date_update

      1234     contacted                   41456.942928241

      1234     converted                    41456.078564815

       

      I want only the latest record to be loaded:

       

      lead_id  status_name_update  status_date_update

      1234     converted                   41456.942928241

       

      This is the table I am using:

      LOAD lead_id,

                status_name_update,

                status_date_update

      FROM

      [C:\XXX.QVD] (qvd);

       

      I have tried multiple solutions from other QV Community posts but cannot seem to get anything working properly. Please help!