topic Re: Stop LOAD at certain point in QlikView

Stop LOAD at certain point

ciaran_mcgowan — Wed, 15 Oct 2014 15:38:03 GMT

Hi,

Is there any way to stop a LOAD from an excel file once a certain value has been reached?

I have an excel file with several tables on the same sheet. I would like to stop Qlikview from reading the entire sheet and only load one table at a time. It would be great if I could stop the load once it reached a field with a set value (i.e. the next table's name).

Re: Stop LOAD at certain point

Wed, 25 Mar 2015 23:03:01 GMT

Did you get an answer for this question? I have run into the same issue with a current standard Excel file containing multiple tables on a sheet and we'd like to import data from those tables but don't know how to stop the load when we hit a blank row.

Did you find a way to do this?

Thanks!

Re: Stop LOAD at certain point

petter — Wed, 25 Mar 2015 23:51:12 GMT

If you define in the Excel sheet each table you want to get hold of separately with a named range - you can specify the named range as the "table" when you run the table files wizard.

Or just specify like this:

LOAD C1,

C2,

C3,

FROM

(ooxml, embedded labels, table is TableA);

Then QlikView will try to find the Named Range in the Excel workbook that is called TableA.