Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have loaded several Excel files into my Qlik Script.
Now I want to create a new Table within Qlik that has some data from the loaded files and generates some additional fields.
To generate the new Data I want to use this solution: https://community.qlik.com/t5/New-to-Qlik-Sense/List-of-dates-between-two-dates/td-p/72525 but I don't want to use inline data but data I already have.
I tried it like this:
table:
LOAD Startdatum, Enddatum, column1, column2, Date(Startdatum+IterNo()-1) as Date
While Startdatum + IterNo()-1 <=Enddatum;
LOAD
Startdatum, Enddatum, column1, column2
;
But I get the error: Field 'Startdatum' not found
What can I do?
Thank you in advance.
Hi
Make sure, startdatum field is available in ur data model and also, in ur script, not able to see the table name itself.
Try like below
table:
LOAD Startdatum, Enddatum, column1, column2, Date(Startdatum+IterNo()-1) as Date
resident urloadedtablename
While Startdatum + IterNo()-1 <=Enddatum;
Hi
Make sure, startdatum field is available in ur data model and also, in ur script, not able to see the table name itself.
Try like below
table:
LOAD Startdatum, Enddatum, column1, column2, Date(Startdatum+IterNo()-1) as Date
resident urloadedtablename
While Startdatum + IterNo()-1 <=Enddatum;
Thank you very much, the resident part was the solution I was looking for