Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can multple excels be loaded in Qlikview
Yes, but depends on the type fields in excel if all file has same sheet then you can use just * symbol to read all file available in the folder
LOAD *
FROM
(ooxml, no labels, table is sheet1);
Load multiple sheets and excel files
Or
LOAD *
FROM *.xlsx
(ooxml, embedded labels, table is [$(*)]);
Regards
Anand
HI,
Try something like this
Directory;
LOAD *
FROM
[*.xlsx]
(ooxml, embedded labels, table is Sheet1);
Hope it helps
Regards
ASHFAQ
Yes,
Multiple Excels can be loaded into QlikView.
Use *.xls to load all excel 2003 files.
Use *.xlsx to load all excel files with this format.
if you have all excel with similar fields an different Name and at same location the use
LOAD *
FROM
[Path\*.xlsx]
(ooxml, no labels, table is sheet1);
other wise
http://community.qlik.com/thread/105143
Shruti,
Code to Access all files in directory (subdirectories)
SUB DoDir (Root)
FOR each File in filelist(Root& '\*.xls')
Tab1:
LOAD <<Field Names>>
FROM
[$(File)]
(biff, embedded labels, table is <<Table name>>$);
NEXT File
FOR each Dir in dirlist (Root&'\*')
CALL DoDir(Dir)
NEXT Dir
END SUB
CALL DoDir('Your Directory');
Code to Access All sheets in a Excel work book
Directory;
for a=1 to 3
LOAD employee
FROM
Looping\constructs1.xlsx // this is the excel sheet name
(ooxml, embedded labels, table is Sheet$(a));// $ sign allows to access the value of a
Next
Code to Access all sheets in a excel work book and convert to QVD
For a=1 to 4
Directory1:
LOAD employee
FROM
Looping\constructs1.xlsx
(ooxml, embedded labels, table is Sheet$(a));
//STORE Directory INTO C:\Users\chaitanyas\Desktop\Looping\Directory$(a).QVD;
Next
STORE Directory1 INTO C:\Users\amits\Desktop\Looping\Directory.QVD;
Drop Table Directory1;
Directory;
LOAD employee
FROM
Looping\Directory.QVD
(qvd);
Thanks,
AS
Hi Shruti
try this script which will load from multiple excel files and also multiple sheets
for each file in FileList('R:\Harsha\qlikview2nd\*.xlsx');
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];
tables:
SQLtables;
DISCONNECT;
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
Table:
Load *,'$(sheetName)' as SheetName
From $(file)(ooxml, embedded labels, table is [$(sheetName)]);
NEXT i
Drop table tables;
//set tables=Null;
Next file
Regards
Harsha