Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

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
Creator
Creator

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

View solution in original post

6 Replies
amilafdo
Creator
Creator

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
Specialist
Specialist

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
Creator III
Creator III
Author

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

amilafdo
Creator
Creator

Hi,

Can you please share the screen shot about modified date?

Regards

Amila

baarathi
Creator III
Creator III
Author

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
Creator
Creator

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