Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
arethaking
Contributor II

Loading xls files dynamically from a folder

I have daily xls file in a folder with the names as 01-06-2016.xls,02-06-2016.xls,03-06-2016.xls,....30-06-2016.xls.

How to load them dynamically?

Thanks in advance.

SampleData is attached.

Data:

LOAD [Serial Number],

     date(floor(Date#([Date & Time],'DD-MM-YYYY hh:mm:ss')),'DD-MM-YYYY') as [Date & Time],

     Originator,

     User,

     Shift,

     [Operator Class],

     [AVC Class],

     [Payment Method],

     Fare,

     [Vehicle Reg. #],

     Description,

     [Amount Due],

     [Amount Paid]

FROM

[Excel\01-06-2016.xls]

(biff, embedded labels, table is Sheet1$);

1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: Loading xls files dynamically from a folder

Change this code:

Excel\01-06-2016.xls

.... to this code:

Excel\*.xls

Alternatively, you could go with this code:

Excel\??-??-20??.xls

... if you have other xls files in that folder you do not want to load.

May you live in interesting times!

View solution in original post

1 Reply
oknotsen
Honored Contributor III

Re: Loading xls files dynamically from a folder

Change this code:

Excel\01-06-2016.xls

.... to this code:

Excel\*.xls

Alternatively, you could go with this code:

Excel\??-??-20??.xls

... if you have other xls files in that folder you do not want to load.

May you live in interesting times!

View solution in original post