create new table from record

[abdulaziz]

Hi all

I have a table from google calendar. 

it's like

event	from	to
new year	28/12/2018	1/1/2019
A	11/11/2018	11/11/2018
B	1/10/2018	2/10/2018

and I want to make like a calendar for integration with my calendar in QlikView

event	Date
new year	28/12/2018
new year	29/12/2018
new year	30/12/2018
new year	31/12/2018
new year	1/1/2019
A	11/11/2018
B	1/10/2018
B	2/10/2018

Can someone help me to make it in the script?

[swuehl · Accepted solution]

Use a WHILE loop in your LOAD statement.

Have a look at

Creating Reference Dates for Intervals

[abdulaziz]

I think you mean IterNo with While

I try this in the link and its work well

many thanks

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/CounterFunctio...