Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Loading Multiple Excel Files In qlikview through Loop

Hiii

I have 30 multiple excel sheet that i have to fetch in qlikview, without fetching it again and again. I just want to reload the application one time and the whole excel sheet should be fetched (in one time) and qvd should me made.

2 Replies
Highlighted
Not applicable

Re: Loading Multiple Excel Files In qlikview through Loop

Hi,

You can use following script:

Load *

From $(Path)\*.xls

(biff, embedded labels, table is Sheet1$);

Regards,

Neha

Not applicable

Re: Loading Multiple Excel Files In qlikview through Loop

HI:

This is my first time posting something, i hope this respond your question:

replay.png

LET vDataFolder = 'C:\Users\mxparedesjl\Desktop\TP_Tecnicos\DB\';
LET vFileName = '';

for Each vFile in FileList('$(vDataFolder)158*.xlsx')

let vFileName = mid(vFile, (index(vFile, '\', -1) + 1),8);

[Engineers]:
LOAD
  $(vFileName)                  AS [Number],
  MakeDate(SubField(Day, '.', 3),SubField(Day, '.', 2),SubField(Day, '.', 1))  AS [Date],
     Wk.time                   AS [Time],
     Doc.                    AS [Document],
     (Differenc * -1)                 AS [Diferrence]
FROM $(vFile)
(ooxml, embedded labels, header is 3 lines, table is $(vFileName));
NEXT