Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
48 results
Sorted by:
2016-02-29
05:27 PM
Hi, I'm trying to load multiple sheets from an excel document. I know there are already many tutorials available. I checked out a lot, but still I don't managed to get it fixed. I tried to r...
2012-05-29
08:43 AM
3 Likes
Hi, I need to load data from multiple Excel files which each contain multiple sheets. I need to filter files by name (eg. *_sys.xlsm) and sheets by names (eg. 'start with number and atleast 4 c...
2017-07-20
10:04 AM
Hi! Can someone help me with my load statement? I am trying to load mulpiple numbered sheets from multiple files. In each file there can be numbered sheets from 1-12 (12 is max, can be less) a...
2018-11-22
02:53 AM
...elow, taken form the following sources: http://qlikviewcookbook.com/2008/09/loading-multiple-excel-sheets/ https://community.qlik.com/t5/QlikView-Scripting/Loading-from-multiple-Excel-f...
Labels
- Subscribe by Topic:
-
General Question
-
Scripting
2016-02-09
11:05 AM
Hi, I have found below given script to load multiple excel sheets, but in the script I am getting error at below given positions I do't know the reason...secondly I want to store the this d...
2015-07-03
08:08 AM
hi, Beginner in qlik view. I used the below script from QV community to load multiple excel worksheets and it worked.All the worksheets have the same format. When i tried to create a list box f...
2016-07-26
07:50 AM
...nviresearch - MS EXCEL ODBC CON;DBQ=$(file)];
tables:
SQLtables;
DISCONNECT;
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(3...
2012-04-23
02:48 PM
1 Like
Have 50 workbooks - one for each customer - stored in "CustomerData" folder. Workbooks can have 1 to 50 worksheets (one for each day with customer data.) In each workbook, worksheets are ...
2023-05-05
02:00 AM
Hello Team,
I am trying load multiple excel sheets via single excel file dynamically, below is the script is working fine in my local machine and same not working in QMC.
Could you please help m...
Labels
- Subscribe by Topic:
-
Application Development
-
Creating Analytics
-
Layout & Visualizations
-
Scripting
2013-11-02
06:49 AM
...e: Re: Pulling multiple excel sheets into QV when all headings are the same
- Tags:
- new_to_qlikview