topic Read all documents in a folder in QlikView

Read all documents in a folder

Wed, 17 Feb 2016 10:50:36 GMT

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

Re: Read all documents in a folder

hic — Thu, 18 Feb 2016 07:43:59 GMT

Use a For each loop. See Loops in the Script

HIC

Re: Read all documents in a folder

tamilarasu — Thu, 18 Feb 2016 07:44:51 GMT

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