Forum Discussion
Solved
Remove duplicates, keep the latest entry (Sharepoint as source)
Hi! I have here a FCONS table that has multiple Reservation No. I only need the LATEST entry of the Reservation No. (highlighted in yellow) I have resolved this before with Table.Buffer...
Hi! Thanks for taking time. I have resolved the issue by sorting descendingly the RunDate then partition by Reservation No. - add index column, expand the partition table and remove its duplicates.
There's a simple trick. Sort your data as needed (which is unfortunate as it is very costly) - in your case you need to sort by Rundate descending - and then select the {Reservation No.] column and choose "Remove Duplicates". That will only keep the first row for each Reservation No. which is actually the last row due to the sorting etc.
I've done this but it doesn't keep the LATEST entry. Any other workaround? Thanks!