Extracting Latest Row by SYS_update_date with All Columns Retained

[noopurjain]

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?

[alexnajm]

Summarize tool - Group By Account and ID and Max the Sys Date should work

[noopurjain]

I tried that, but it filters out some columns from my data, and I need all columns retained.

[alexnajm · Accepted solution]

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

[binuacs · Accepted solution]

@noopurjain similar to @alexnajm approach