my data from tables got deleted after load script runned its normal ?

[Anonymous]

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

[dplr-rn]

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