topic Re: INCREMENTAL LOAD AND CONCATENATE in QlikView

INCREMENTAL LOAD AND CONCATENATE

Fri, 18 Apr 2014 12:10:29 GMT

Hi

Can someone please help me with the Concatenate and incremental Load for Insert only.

As per my understanding incremental load is like SQL insert /Update statement, if wrong please correct

Kindly go through the example given below

INITIAL LOAD

TEMP1:

Load

EmpID,

Name,

Designation

FROM

…….TAB1

STORE TEMP1 INTO TEMP1 QVD;

TEMP2:

Load

EmpID,

Name,

Designation

FROM

…….TAB1

Now table TEMP1 contains EmpID record from 1-8 and table TEMP2 contains EmpID record from 9-15,The Stored qvd TEMP1.qvd contains he record of both the table….i understood both the tables got concatenated how will i differentiate it from Incremental load.

Thanking You

Vinayagam

Re: INCREMENTAL LOAD AND CONCATENATE

swuehl — Fri, 18 Apr 2014 12:39:05 GMT

I would suggest that you download the QV cookbook from Rob's download page, where you'll find a detailed and commented script for all kind of incremental loads (also insert only type).

robwunderlich.com/downloads/cookbook_v10c_PE.zip

Re: INCREMENTAL LOAD AND CONCATENATE

Fri, 18 Apr 2014 12:58:59 GMT

Yup Thanks Sir