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?