Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello im new to Qlik and i hope i can get some awnsers, because after searching i didnt find any for my question.
The thing is i have a database with many tables so i created load script to get all the tables i need for qlik, and i need to do incremental load in one of them, so i created a QVD file for one table, and for that specific table it works amazing, but for the other tables all the data is erased.
So my question its , is it normal to do that ?
I need one QVD File for each table or there is some configuration for that ?
Thanks in advance
Paulo Pinho
When ever a new reload is performed all data gets erased.
if all tables needs to be stored as qvd you can use a for loop like below at the end of the script
FOR vCount = 0 to NoOfTables()-1
LET vTableName = TableName($(vCount));
STORE $(vTableName) INTO $(vTableName).qvd (qvd);
NEXT vCount