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
PhilipTreacy
Super User
Super User
Then load the CSV files using the from folder connector and the subsequent query stesp will still be the same.
Regards
Phil