Append data from csv to QVD files

Mon, 27 Feb 2012 10:18:59 GMT

Can any one tell me how to append data from csv file to qvd.

Actually our scenario is something like that: Every day we ll get new csv with new data for each table. Instead of taking data from table , we want to take from csv file itself and append to existing qvd files. I tried this code:

QV_Table:

SQL SELECT * FROM abc.csv

Concatenate LOAD * FROM abc.QVD;

STORE QV_Table INTO abc.QVD;

Its working fine. But my understanding is this code works in this way :

Step1:1st take data from csv file.

Step2: Take data from existing qvd files.

Step 3:Concatenate and then finally store into qvd files.

Since our existing qvd files having very huge data thats why we dont want again to take data from qvd files. Our step should like that:

Step1: Take data from csv file.

Step2: Append data to qvd files.

Same thing we also want to do with our qvw should take only modify data from qvd files instead of loading all data .

Append data from csv to QVD files

jvitantonio — Mon, 27 Feb 2012 10:23:03 GMT

Hi, you should check the Incremental load capability of Qlik .Check out reference manual and help.

topic Append data from csv to QVD files in QlikView

Append data from csv to QVD files

Append data from csv to QVD files