Yes ofcourse, use the logic of "Incremental load" for insert where you will be loading the qvd + your new data, both of them will be concatenated after loading and just create a new qvd with the same name which will replace the old one
containing old + new records
Share some sample so that we can explain the process
This is great but only solves half the problem. I do not want to load new data from a DB or Excel file. I want to create it in a Qlik script.
How should I do that?
What I'm thinking of doing is using a do while loop to increment a variable by 1. Inside the loop I will do all my formatting and then insert it into an inline table.
The inserting these calculated fields into the inline table is where I'm drawing a blank.
Maybe create a communal Master Calendar for say this and next decade - then when you load it use a where clause to just bring in the date range you want.
