Forum Discussion
Filter ticket column based on last update
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
Super User
This file loads 2 CSV files from a folder on my PC. I'm using that as the example here. You will need to create your own query to load your CSV files but you can then add on my query steps to yours, starting from 1. below.
To illustrate loading from CSVs in folder,
In the next step choose Combine and Transform Data
You end up with this table in Power Query and a load of Helper queries created by PQ to load and transform the CVS files. Now you can start doing your own transformations
Then what I've done is :
1. Delete the Source.Name column
2. Grouped Rows
3. Merged tables. This step is done manually. What is happening is that the query is merging the table created by the #"Grouped Rows" step, and the table created by the #"Changed Type" step.
Open the Advanced Editor and enter the Merge step as shown below. Just copy/paste my code. Change the in section to return Merge
4. Expand Grouped Rows. You only need Subject and Status.
5. Reorder columns
Regards
Phil