Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
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

Community Browser