Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community ,
I have 17 excel sheet month wise (Jan 2022 to may2023) how I load all sheet in QlikView?
for example:-
load
a,
b,
c,
FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (1).xls]
(html, codepage is 1252, embedded labels, table is @2);
load
a,
b,
c,
FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (2).xls]
(html, codepage is 1252, embedded labels, table is @2);
load
a,
b,
c,
FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (3).xls]
(html, codepage is 1252, embedded labels, table is @2);
have 17 excel sheet month wise (Jan 2022 to may2023) how I load all sheet in QlikView?
for example:-
load
a,
b,
c,
FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (4).xls]
(html, codepage is 1252, embedded labels, table is @2);
and so on till may2023 how i load all sheet in qlikview.