How to edit my current search to remove duplicate rows from the resulting table?

[shivendra_infy]

Hi

I am using a table which shows up duplicates. Example shown below.
Is there a way to write a search which removes duplicates from the table?
I am pasting the search here for reference.

*index= source="dbmon-tail://db" Status = "2" Track_Name = "Ab-Initio"|convert timeformat="%Y-%m-%d %H:%M:%S" ctime(_time) AS UpdateDateTime |table UpdateDateTime, Track_Name,Application_Name,Component_Name,Status_Desc,lts_error_description,Comments

This above search returns the two rows below, of which I need only the latest one based on date.

[rjthibod]

I think it would be helpful if you could expand on what fields determine the unique rows you want to keep. Right now that seems unclear.

[richgalloway]

Look into the dedup command.