make new table with already Loaded data

[lolasamsung]

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.

[MayilVahanan · Accepted solution]

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;

[lolasamsung]

Thank you very much, the resident part was the solution I was looking for