Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use a WHILE loop in your LOAD statement.
Have a look at
I think you mean IterNo with While
I try this in the link and its work well
many thanks