topic Loading Multiple Excel Files In qlikview through Loop in QlikView

Loading Multiple Excel Files In qlikview through Loop

Mon, 03 Dec 2012 05:00:45 GMT

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.

Re: Loading Multiple Excel Files In qlikview through Loop

Mon, 03 Dec 2012 07:55:31 GMT

Hi,

You can use following script:

Load *

From $(Path)\*.xls

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

Regards,

Neha

Re: Loading Multiple Excel Files In qlikview through Loop

Thu, 06 Dec 2012 18:47:25 GMT

HI:

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

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