Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading data from Excel sheet until blank row

Hi!

I have the following dataset:

Each month, a row is added manually in the first table, and I only want to load this table in Qlikview through "Plaintext Files" option in the Script Editor. But when I try to do it, it loads the three tables:

So I would like a way to load automatically only the data until the first blank space at the top and at the right of the first table without having to remove any rows with the transformation option in the load of Qlikview.

Thanks in advance!

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

You need to know how many rows you want to load - with a first-statement - and/or a clear defintion how the data must look like - with a where-clause. This meant something like this:

table:

First 13 Load Month, Value From YourExcel;

or

table:

Load Month, Value From YourExcel where len(Month) = 6;

- Marcus

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You need to know how many rows you want to load - with a first-statement - and/or a clear defintion how the data must look like - with a where-clause. This meant something like this:

table:

First 13 Load Month, Value From YourExcel;

or

table:

Load Month, Value From YourExcel where len(Month) = 6;

- Marcus

Not applicable
Author

Ok thanks! I though that it would be an automatic mechanism in order to stop the load when the first blank row is found...

I will take your second approach! Thank you very much for your effort!