I have a folder with qvds which are named like 09-xyz.qvd or 12-xyz.qvd
The number at the beginning is always the hour of the export, so the greater the number the later the export.
With the script below I load them all and concatenate them to one table. I need them all in one table for another calculation.
After the calculation in another table I want to filter the initial table test so that I only have the rows from the latest file which is the max of _Hour.
I tried it with the inner keep load to just keep the rows with max(_Hour) as you can see. Tried it with a small self-written data sample which worked fine. Afterwards I tried it with this for-loop and the resulting big test table (2.7 Mio rows) and without the calculation between. The filter works somehow as it just keeps 346k rows but it still has 9 and 12h rows. Am I doing any mistake here? Shouldn't it just keep the rows with 12 as _Hour because its the max?