Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Is there any variable called Ext in your Sub Routine ??
Have you got this working?
It works! Thanks Sasidhar.