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.
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.