topic Re: Data loading "*" command in path name? in QlikView

Data loading "*" command in path name?

Fri, 12 Jun 2015 08:46:04 GMT

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!

Re: Data loading "*" command in path name?

alexandros17 — Fri, 12 Jun 2015 08:49:57 GMT

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

Re: Data loading "*" command in path name?

qlikmsg4u — Fri, 12 Jun 2015 08:50:45 GMT

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