Forum Discussion
Solved
Filter ticket column based on last update
Hi All, I have a lot of double records in my dataset. Here's an example: I only want to have unique "Ticket ID" records based on "Last Updated Time" and (obv.) filter out the older ones. ...
I've added in the necessary steps to your query. I didn't change your Source location as I aded the files to my PC in the same path.
After the Grouped Rows step, I manually entered the Merge step. This merges the #"Grouped Rows" step with the table that results from the step immediately above it, #"Removed Columns".
The result is a table with just the Latest Updated rows.
Regards
Phil
And what if my data comes from a folder with a couple of CSV's in it?
All CSV's contain the same structure but with different data. (that why I want to sort for last update)
Ashish_Mathur
Super User
Super UserHi,
Share the link from where i can download your Excel file.