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?
You have attached excel instead of workbook
You can refer below
Please mark the answer as CORRECT & HELPFUL if it really helps you so that it can help others as well