Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data loading "*" command in path name?

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!

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Yes, your answer describes exactly how the script works ...

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Yes, your answer describes exactly how the script works ...

qlikmsg4u
Specialist
Specialist

It mean that QlikView will read ALL the Excel spreadsheets in that particular folder