topic Re: Partial Load in QlikView

Partial Load

Thu, 27 Aug 2015 11:49:29 GMT

hi Community,

I have couple of doublts on Partial load like below.

Ex :

Table

Dim1

Now

I have replaced 3 with the value of 4 in Dim1 like,

Table

Dim1

what should I use here

kaushiknsolanki — Thu, 27 Aug 2015 11:52:24 GMT

Hi,

You should just use the full load.

Partial load is used to add a new table in your datamodel, without loading other tables.

Regards,

Kaushik Solanki

Thu, 27 Aug 2015 15:04:27 GMT

Is it not possible to load only updated records with out loading another tables.

Digvijay_Singh — Thu, 27 Aug 2015 15:39:04 GMT

For that we need to maintain timestamp in source file to recognize which records are changed after last reload.

Something like this - Search 'QVD files and Incremental Load' in help, you will get more details

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#;

Concatenate LOAD

PrimaryKey, X, Y FROM File.QVD

WHERE NOT Exists(PrimaryKey);

STORE QV_Table INTO File.QVD;