Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

drose4802
New Contributor II

Partial Load

I have several years of Excel data in separate year files. (Example: 2014 sales, 2015 sales etc...). As I continue to add 2017 data as part of the overall load statement, the time it takes the load to run is increasing.

I'd like to update the 2017 Excel file and only spend the time reloading that data instead of all the other files as that data has not changed. How do you write the load statement to keep the old sales years data and only load or run the 2017 file?

LOAD

  [Category],

  [Sales

Category],

  [Product

Code],

FROM [lib://QlikSense/2016 Sales.xlsx]

(ooxml, embedded labels, table is Table1);

LOAD

    Category,

    "Sales

Category",

    "Product

Code"

FROM [lib://QlikSense/2017 Sales.xlsx]

(ooxml, embedded labels, table is Table1);

1 Reply
vishsaggi
Esteemed Contributor III

Re: Partial Load

Just Try this?

LOAD

  [Category],

  [Sales

Category],

  [Product

Code],

FROM [lib://QlikSense/2016 Sales.xlsx]

(ooxml, embedded labels, table is Table1);

ADD

LOAD

    Category,

    "Sales

Category",

    "Product

Code"

FROM [lib://QlikSense/2017 Sales.xlsx]

(ooxml, embedded labels, table is Table1);

And then just go to File - Click Partial Reload. OR Ctrl+Shift+R