1 Reply Latest reply on Nov 7, 2018 5:54 PM by Ritesh Bisht

    Filtering duplicates

    Mike Rasic

      Our data infrastructure is set up in a way that "User ID" is the unique identifier across all tables.  One of our tables has attributes (Parasail Credit Report) per User ID, which creates duplicates across the entire merged set (I'm joining 5 tables overall).  I only want to use attribute with the latest "created date (c)".  Ideally I'd filter for this in Prep but if needed can do it in Desktop as part of the analysis.  The attached workbook shows how two of the duplicates are created as well as examples of clean data.

       

      Any thoughts on the best way to accomplish this?