Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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