1 Reply Latest reply: Sep 11, 2013 5:18 AM by Tresesco B RSS

    Using both WHILE and WHERE statement in a LOAD

    Erik van hout

      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?