Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all lovely people,
I always have a monthly Excel File (XLS format) with different number of sheets in every month.
At the moment, i need to change certain in order to absorb the difference of sheet numbers.
Not only that, the previous loaded Excel file will not always be kept after i have a new monthly excel file in the qliksense.
Hence i am looking a way to solve above both issues (Load the file no matter the number of sheets & Keep the previous loaded file).
Please find screenshot my scripting and my excel file sturcuture.
try like this:
Table:
LOAD [Main Order],
Order,
OT,
Reference,
Article,
Type,
[invoice mark],
qty_ordered,
Sales_Price_in_MYR,
Incurred_Costs,
curr,
[curr rate],
per
FROM
[C:\Users\admin\Desktop\Mappe1.xlsx]
(ooxml, embedded labels, table is Sheet1);
For i = 2 to 1000 //choose high number according the number of your sheets
vSheet = 'Sheet'& i
Concatenate(Table)
Load
A as [Main Order],
B as Order,
C as OT,
D as Reference,
E as Article,
F as Type,
G as [invoice mark],
H as qty_ordered,
I as Sales_Price_in_MYR,
J as Incurred_Costs,
K as curr,
L as [curr rate],
M as per
FROM [C:\Users\admin\Desktop\Mappe1.xlsx]
(ooxml, no labels, table is $(vSheet));
next