Hi All,
With the assistance of Ali a couple of weeks ago, she created me a PQ table based upon the data in an input table. The input data grows daily. The PQ looks at the input data , finds records based upon a minimum time value, and creates an output table. Works a treat.
However, I am finding the input table is growing rapidly. Because I only need the minimum time records, all other records in the input table are of no value.
Ideally, to speed things up, I would like to delete records from the input table that are not a minimum time value.
Essentially, compare the input table with the output table and delete the differences.
I am looking for some guidance because what I have tried is either unsuccessful or just to slow. PQ is so much faster.
I have attached a sample workbook.
Any assistance would be great.
Bookmarks