Read all documents in a folder

[#1]

Hi there,

Is it possible to place lots of Excel documents in a directory (all of the same structure) and have Qlikview read them all, without needing a load script for each?

Thanks

[hic]

Use a For each loop. See Loops in the Script

HIC

[tamilarasu]

Hi,

Try,

For each vFile in FileList('$(vPath)\*.xl*')

     let vFileFormat = if(right(vFile, 1) = 'x', 'ooxml, embedded labels, table is Sheet1', 'biff, embedded labels, table is [Sheet1$]');

     TableName:

     load

          '$(vFile)' as SourceFile,

          *

     from [$(vFile)]

     ($(vFileFormat));

next

Check the below link

How to load multiple xls files in script