monthly and yearly QVD files from one big table

[nk16_]

Hi everyone,

I have a table with millions of rows and for reloading, it takes more than 16 hours... I would like to find a way to be faster. - To split the data before loading.

The table has data for 2 years for now.

Maybe I have to can create a loop to go over month by month, extract one month at a time, and store it to QVD and drop the table once it creates the QVD. 

Can someone give me some advice?

Thank you! 

[Qlik1_User1 · Accepted solution]

Hi @nk16_ 

instead of that create an incremental load for that table..

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-fil...