Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

baarathi
Contributor

Incremental load

How to perform incremental load for following sample data?

LOAD

    "Row ID",

    "Order ID",

    "Order Date",

    "Order Priority",

    "Order Quantity",

    Sales,

    Discount,

    "Ship Mode",

    Profit,

    "Unit Price",

    "Shipping Cost",

    "Customer Name",

    Province,

    Region,

    "Customer Segment",

    "Product Category",

    "Product Sub-Category",

    "Product Name",

    "Product Container",

    "Product Base Margin",

    "Ship Date"

FROM [lib://Temp/Sample - Superstore Sales (Excel).xls]

(biff, embedded labels, table is Orders$)

1 Solution

Accepted Solutions
amilafdo
Contributor

Re: Incremental load

Hi,

This can be done as below.

1 st you have to define the variable path for vToday for increment data (this has to define if you want to segregate the date by data)

//Load existing data

Load *

from

Sample - Superstore Sales.qvd

(qvd);

concatenate

//Load incremental data to the above 

Load * from

[lib://Temp/Sample - Superstore Sales (Excel)$(vToday).xls]

(biff, embedded labels, table is Orders$)

//Store combine data in to qvd

Store Sample - Superstore Sales into Sample - Superstore Sales.qvd;

Drop table Sample - Superstore Sales;

//Refer the newly created "Sample - Superstore Sales.qvd"


Thanks

Amila

6 Replies
amilafdo
Contributor

Re: Incremental load

Hi,

This can be done as below.

1 st you have to define the variable path for vToday for increment data (this has to define if you want to segregate the date by data)

//Load existing data

Load *

from

Sample - Superstore Sales.qvd

(qvd);

concatenate

//Load incremental data to the above 

Load * from

[lib://Temp/Sample - Superstore Sales (Excel)$(vToday).xls]

(biff, embedded labels, table is Orders$)

//Store combine data in to qvd

Store Sample - Superstore Sales into Sample - Superstore Sales.qvd;

Drop table Sample - Superstore Sales;

//Refer the newly created "Sample - Superstore Sales.qvd"


Thanks

Amila

tomasz_tru
Valued Contributor

Re: Incremental load

It depends on the characteristic of the data - different scenarios are possible. There's good article:

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

baarathi
Contributor

Re: Incremental load

It shows a modified date, but i dont have a field called modified date, In this case how to do?

amilafdo
Contributor

Re: Incremental load

Hi,

Can you please share the screen shot about modified date?

Regards

Amila

baarathi
Contributor

Re: Incremental load

in the below link there is a modified date if I don't have modified date field.How to proceed with it?

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

amilafdo
Contributor

Re: Incremental load

Hi,

I think you have increment data in excel so you don't worry about the modified date, you just maintain the vToday().

If you have all the data in excel including increment you can use Order date on be half of modified date.

Hope this is clear and fulfill you requirement.

Regards

Amila