Using both WHILE and WHERE statement in a LOAD

[#1]

Upon loading the DataTable from a temporary table I'd like to accomplish two things:

1. Add dates from a date range

2. Clean up the rawdata by deleting empty records and subtotals

I've added a WHILE-statement to add the dates (point 1).

But I can't figure out how to combine the WHILE-statement with a WHERE-statement.

I've added an example-file to show in more detail what I'm looking for.

Does anyone know how to combine the WHILE and WHERE Statement?

[tresesco · Accepted solution]

May be like this? PFA.

Edit: Corrected the app, please find the new one.