Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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