Loading multiple xls-files data

[Anonymous]

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.

[sasiparupudi1 · Accepted solution]

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

[Anil_Babu_Samineni]

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

[sasiparupudi1]

Have you got this working?

[Anonymous]

It works! Thanks Sasidhar.