Conditional stop when loading from Excel

Mon, 29 Oct 2012 09:01:00 GMT

Hello,

I have a big Excel file with more than one data table on the same sheet, and I'm trying to load only the first one. This file look like this (this is only a few columns, there is a lot more in the actual file) with 10 different tables, one after another just like that :

Titre_niveau_1	Titre_niveau_2	Intervenant	Profil projet
ATR	Initialisation	FDI	DP
ATR2	Initialisation	CAU	DP
SZA	Initialisation	JFR	CP

Total charge :

Titre_niveau_1	Titre_niveau_2
ATR	Initialisation
QTR	Transition
PTZ	MCO

I want to stop the loading when the first column = 'Total charge :', but I don't know the right way to do it in Qlikview. While loop ? (i tried it, but it was restarting the loading when it stopped). Is there a way to "tell" Qlikview to stop with a conditon ?

Thank you for your help !

Re: Conditional stop when loading from Excel

flipside — Mon, 29 Oct 2012 10:20:43 GMT

Hi pioubluh,

Try running two commands against the excel file - the first one to identify the row the 'stop' data appears on, and the second to return only the rows you need based on this value, something like this ...

RowLimit:

FIRST 1

LOAD

RecNo() as RecRef

FROM

[SubjData.xls]

(biff, embedded labels, table is Sheet1$)

where Titre_niveau_1='Total charge :';

Data:

FIRST peek('RecRef')-1

LOAD

FROM

[SubjData.xls]

(biff, embedded labels, table is Sheet1$);

flipside

topic Conditional stop when loading from Excel in QlikView

Conditional stop when loading from Excel

Re: Conditional stop when loading from Excel