Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ceruli13
Contributor
Contributor

Divide QVD with incremental load

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.

Labels (2)
0 Replies