Afternoon,

Looking for some assistance with a data load script in Qlik Sense please.

I am currently loading the following data into a table called 'ORDERS' via Qlik Sense script:

Order               Start Date               End Date

12345                 13/04/21                15/04/21

76854                 17/04/21                21/04/21

What I would like to do is to generate a new table using this data, with an entry for every date within the range (start to end). In the above example, the output would be:

Order           Date

12345           13/04/21

12345           14/04/21

12345           15/04/21

76854           17/04/21

76854           18/04/21

76854           19/04/21

76854           20/04/21

76854           21/04/21

How could I transform the data into this format from within the script?

Many Thanks

Craig