Forum Discussion

hmenco's avatar
hmenco
Frequent Visitor
5 years ago
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...
Need Help
  • hmenco's avatar
    hmenco
    5 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

ImkeF thank you for the warning. Since this is a SharePoint source I assume no query folding is happening and the sort is safe-ish?

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
5 years ago

Hi lbendlin ,

no, that's not how I understood the thread:
.." or because when run locally it may constraint the operators in some ways that would make the operation inefficient or impossible to enforce.."
To me this means that even locally evaluated queries won't have a guaranteed sort order.