Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sHi
I am looking through a script written by my predecessor, and came across this line during the data loading:
LOAD
Customer,
SalesValue
[$(vDataPath)\*.xls]
(biff, embedded labels, header is 1 lines, table is [Data1]);
As I do not currently have access to the data warehouse structure, can anyone explain what does the "*.xls" mean? Does it mean that QlikView will read ALL the Excel spreadsheets in that particular folder, and extract all fields with "Customer" and "SalesValue" as headers and if the table is named "Data1"?
Thanks in advance!
Yes, your answer describes exactly how the script works ...
Yes, your answer describes exactly how the script works ...
It mean that QlikView will read ALL the Excel spreadsheets in that particular folder