Divide QVD with incremental load

ceruli13 — Thu, 14 Oct 2021 10:23:22 GMT

Hi,

I have to work with a volume of data in a very large DB table, so I have decided to do an incremental load and store it in a QVD.
The problem is that I don't want the size of the QVDs to be more than 6GB. Doing tests for about nine million records, the resulting QVD is 2GB, so I want to control that when doing the incremental load of the data when it passes, for example, 20 million records, it starts to store in a new QVD, and from this way to have several QVD files of about 6GB each.

My code contains:

FOR

--- SQL Code for data

Concatenate LOAD * FROM C:\temp\file.qvd (qvd);
STORE My_Table INTO C:\temp\file.qvd;
DROP Table My_Table;

NEXT;

I am new to qlikview and I don't know how I can control within my for loop the number of records that I am loading.

Any help?

Thanks in advance.

topic Divide QVD with incremental load in QlikView

Divide QVD with incremental load