Extracting Latest Row by SYS_update_date with All Columns Retained

Question

Hello,

For an account with multiple rows and IDs, I need a single row that reflects the latest SYS_update_date. I tried using the summarize function, but it didn't work as I need all the columns in my dataset. In the attached example, I specifically need the fields highlighted in yellow. Could you please help?

alterys ques.xlsx

alexnajm · Accepted Answer

Then use that output and Join it back to the original records to essentially act as a filter on your data

binu_acs · Accepted Answer

@noopurjain similar to @alexnajm approach