Discussion Board for collaboration related to QlikView App Development.
How to load date from multiple sheets from one excel file at a time into QV ?
By sheet by sheet like
first load sheet1 & next step load sheet2
At a time is not possible I think so......
If you get any solution post here..........
go to Edit script and give alias name and type as below.
prod< alias name>
Load * from Sheet1 ;
Load * from Sheet2;
the above is the screen shot that is used to load multiple sheets in an excel file into the qvw appl my sheets are 3pl inventory, summary,qty recoth
Please follow my suggestion here below:
. If an excel file contains multiple sheets with different data\table . how to create a qvd for each...
At a time we can not load right?
At a time you can not load multiple sheet from one excel file,you need to load data of sheets one by one.
here is the Script:(works irrespective of number sheets/sheet names).
ODBC CONNECT32 TO [Excel Files;DBQ=C:\MPA\Book1.xlsx];
DISCONNECT; // Don't need ODBC connection anymore
One of the fields loaded by SQLtables is "TABLE_NAME". This field will contain the sheet name.
We will loop through this set of sheet names.
FOR i = 0 to NoOfRows('tables')-1
Assign the TABLE_NAME to the variable "sheetName".
TABLE_NAMEs that contain spaces will be enclosed in single quotes.
The purgeChar function will remove any quotes AND dollar signs.
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
// Optional filtering logic to select certain sheets
// Now that we have a sheet name, a standard biff (Excel) load can be used.
'$(sheetName)' as Sheet // Optionally, the sheetName value may be loaded as a field
FROM C:\MPA\Book1.xlsx (ooxml, embedded labels, table is [$(sheetName)]);
Please refer Load Multiple excel sheets using For loop
SET i = 'Sheet2','Sheet3';
for each m in $(i);
(ooxml, embedded labels, table is $(m));