How to Update and Filter from max date

[golmalrc]

Basically, I have records in the following Format

RECORD_ID	LAST_UPDATE	FRUITS	CARS
10023	2023-03-21	Apple	Chevy
10023	2023-06-17	Guava	Porsche
10023	2023-10-18	Pineapple	Nissan
10414	2023-08-23	Peach	Chryslar
10414	2023-10-11	Guava	Mercedes
10657	2023-04-22	Grapes	Toyota
10657	2023-07-16	Apple	Renault
10657	2023-09-25	Pineapple	Kia
10657	2023-10-24	Peach	Subaru

Desired Output is Unique RECORD_ID by "Max Date" Row

RECORD_ID	LAST_UPDATE	FRUITS	CARS
10023	2023-10-18	Pineapple	Nissan
10414	2023-10-11	Guava	Mercedes
10657	2023-10-24	Peach	Subaru

Any idea/s on how to do this will be greatly appreciated. Thanks.

[TimN]

Try something like the attached

[golmalrc]

Yes, this works beautifully. Many Thanks. I forgot that Unique function picks up the first occurrence of duplicates.

[TimN]

Hi Golmalrc,

Can you mark my answer as the accepted solution when you get a chance?

Thank You,

Tim