I’ve always found that adding an index retains the sort order prior to removing duplicates and will work with larger datasets which you would not want to buffer - Nice to see sunny Brisbane out the window!
Thanks for the comment. In some situation I use the column I want to use for removing duplicate in a custom column and then used this new column for removing duplicate after sorting, but I didn't know adding index column can be used also. Yes, We are experiencing spring this days in Brisbane.
Excellent analysis and resolution. Thanks for reporting, Omid.
You are welcome
I’ve always found that adding an index retains the sort order prior to removing duplicates and will work with larger datasets which you would not want to buffer - Nice to see sunny Brisbane out the window!
Thanks for the comment. In some situation I use the column I want to use for removing duplicate in a custom column and then used this new column for removing duplicate after sorting, but I didn't know adding index column can be used also.
Yes, We are experiencing spring this days in Brisbane.
Sizin videonuzu izleyene kadar yinelenenleri kaldırmadan önce indeks dizini ekleyip kaldırıyordum. Bu yöntem daha pratik. Teşekkürler.
You are welcome
Thank you for this information. Does Table.Buffer() prevent query folding when used this way?