topic Re: Loading multiple xls-files data in QlikView

Loading multiple xls-files data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 18 Apr 2018 08:50:22 GMT

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 — Wed, 18 Apr 2018 08:54:50 GMT

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

sasiparupudi1 — Wed, 18 Apr 2018 12:35:25 GMT

Have you got this working?

Anonymous — Thu, 19 Apr 2018 03:14:26 GMT

It works! Thanks Sasidhar.