Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
1 Solution

Accepted Solutions
tresesco
MVP
MVP

This is working for me:

LOAD

    "Month",

    "Forecast CAPEX",

    "Forecast GFC",

    "Initial CAPEX",

    "Initial GFC"

FROM [lib://aaa/trash.xlsx]

(ooxml, embedded labels, header is 16 lines, table is Sheet1) where RecNo()<13;

View solution in original post

9 Replies
tresesco
MVP
MVP

You could probably increase/decrease the Header size to browse to different table in the same sheet.

Capture.JPG

xyz1
Creator III
Creator III
Author

.

tresesco
MVP
MVP

If this is a static data source you could put a condition for upper tables to tell how far (may be row count) to fetch the data for that specific table. May be like:

Load

          *

From [lib://....] Where RecNo()<100;

Or you may put a flag in between to check to put a break in the load.

xyz1
Creator III
Creator III
Author

.

tresesco
MVP
MVP

No. I meant to insert a static value for your fist column. But that would not be an easier option I realize. So better stick with the row count method if that solves your purpose.

xyz1
Creator III
Creator III
Author

.

tresesco
MVP
MVP

Yes, without that brackets for where clause, like

FROM [lib://Trend/Trend.xlsm] Where RecNo()<12 ;

Isn't it working?

xyz1
Creator III
Creator III
Author

.

tresesco
MVP
MVP

This is working for me:

LOAD

    "Month",

    "Forecast CAPEX",

    "Forecast GFC",

    "Initial CAPEX",

    "Initial GFC"

FROM [lib://aaa/trash.xlsx]

(ooxml, embedded labels, header is 16 lines, table is Sheet1) where RecNo()<13;