topic Re: Load all files dynamically from folder in QlikView

Load all files dynamically from folder

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

HI Experts,

I am having one main folder called "Folder". In this folder i have some files

Jan.xlsx,

Feb.xlsx,

Mar.xlsx

...........

now i want load all excel files dynamically in single statement from mail "folder"

Thanks in advance

Gysbert_Wassenaar — Thu, 16 Feb 2017 12:36:53 GMT

See this blog post: Loops in the Script

dsharmaqv — Thu, 16 Feb 2017 12:54:43 GMT

try this

FOR each vFile in filelist('$(vSourceLocation)/*.xlsx')

LOAD
A,
B,
C

FROM
[$(vFile)];
NEXT

marcus_malinow — Thu, 16 Feb 2017 15:35:19 GMT

Alternative would be to use a wildcard in the filename in your load script:

Data:

LOAD

FROM

[directory\*.xlsx]

albertovarela — Thu, 16 Feb 2017 17:58:11 GMT

Just make sure tabs on all files are named the same way... e.g. (ooxml, embedded labels, table is Sheet1)

avinashelite — Thu, 16 Feb 2017 18:15:01 GMT

Check this thread