Incremental load

[baarathi]

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$)

[amilafdo · Accepted solution]

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]

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]

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

[amilafdo]

Hi,

Can you please share the screen shot about modified date?

Regards

Amila

[baarathi]

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]

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