Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Loading multiple xls-files data

Hi,

I am using Qliksense and I would like to record the information of all xls/xlsx files in folder. But I am getting the error over and over again.

Any idea of this error? Here is the script as well.

Error.JPG

Shot.JPG

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: Loading multiple xls-files data

Change the line

For Each tblFile in FileList(Root & '\*.' & FileExtension)



Let Root='\\lnn63f1\u_t1487402003\sasidp\My Documents';

For Each FileExtension in 'xls','xslx'

For Each tblFile in FileList(Root & '\*.$(FileExtension)')

tbl_File:

LOAD Distinct

'$(tblFile)' AS FileName,

FileSize('$(tblFile)') As FileSize,

FileTime('$(tblFile)') As FileTime

AutoGenerate 1;

Next tblFile

Next FileExtension

View solution in original post

4 Replies
Highlighted
Master III
Master III

Re: Loading multiple xls-files data

Change the line

For Each tblFile in FileList(Root & '\*.' & FileExtension)



Let Root='\\lnn63f1\u_t1487402003\sasidp\My Documents';

For Each FileExtension in 'xls','xslx'

For Each tblFile in FileList(Root & '\*.$(FileExtension)')

tbl_File:

LOAD Distinct

'$(tblFile)' AS FileName,

FileSize('$(tblFile)') As FileSize,

FileTime('$(tblFile)') As FileTime

AutoGenerate 1;

Next tblFile

Next FileExtension

View solution in original post

Highlighted

Re: Loading multiple xls-files data

Is there any variable called Ext in your Sub Routine ??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master III
Master III

Re: Loading multiple xls-files data

Have you got this working?

Highlighted
Contributor III
Contributor III

Re: Loading multiple xls-files data

It works! Thanks Sasidhar.