Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You can use following script:
Load *
From $(Path)\*.xls
(biff, embedded labels, table is Sheet1$);
Regards,
Neha
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