Log In
Register
Home
Active Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Expert
May 21, 2021
Offline
Hello, I have a data table that needs to be updated daily with new entries containing duplicate IDs within the ID column. I am looking for a solution to remove the previous rows that match the new entry based on the ID number while keeping the latest entry intact. I have tried to come up with a solution but need help. Could you please provide me with the necessary Mcode or guidance to help me create this process? Thank you.
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
Could you please upload a file with some sample data that resembles your real situation? It's so much easier to help with some real data to work with.
Active Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Expert
May 21, 2021
Offline
My apologies. I appreciate your help. I have attached a sample data file.
Trusted Members
October 18, 2018
Offline
How do you identify the latest entry. The only dates I see are listing and closing dates. Am I missing something?
Active Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Expert
May 21, 2021
Offline
As new data is added, it is appended. I am a newbie here. My thought was to add an index column as one of the first steps. I don't know, really. Maybe I need to add a date column to the raw data before loading it to power query?
The CDOM (Cumulative Days on Market) column may be the best resource for identifying the latest entry unless there were multiple changes to an MLSNumber on the same day. I really don't know what the best practice is.
Your guidance is appreciated!
Trusted Members
October 18, 2018
Offline
In my mind the best method would be a date time field that indicates the updates. Then the latest record can be maintained and any earlier records removed. Update your workbook to indicate same and we can then provide a functional solution.
1 Guest(s)
