We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

How to Detect and Remove Duplicates in Data360 Analyze

Follow

Comments

2 comments

  • Avatar
    Daniel Rempel

    I have duplicate records of the same transaction, and want to preserve the most recent one. How can I do that?

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    After you have used the Duplicate Detection node to find the duplicates, add a Sort node and configure the SortBy fields to be the same as the key fields used by the Duplicate Detection node plus the Transaction date field. This should be configured to sort descending - meaning the first record in the duplicate group will be the most recent. You can then use the Duplicate Detection node to delete the earlier duplicate record(s).

     

    0
    Comment actions Permalink

Please sign in to leave a comment.