topic Re: load just last row from excel in QlikView

load just last row from excel

Wed, 25 Nov 2020 16:16:04 GMT

i want load just last row from excel file

i see post about this problem but dont work for me

load last n rows from excel

please guide me

tanks

Re: load just last row from excel

tresB — Mon, 04 Sep 2017 05:55:59 GMT

If those solutions don't work for you, it could be that the issue is a specific one for your file or how you are trying. Could you explain- how your excel looks like and how exactly you are trying?

Re: load just last row from excel

Mon, 04 Sep 2017 05:57:48 GMT

my file is normal

please see 1.qvw file

Re: load just last row from excel

tresB — Mon, 04 Sep 2017 06:13:49 GMT

Try like:

temp:

LOAD

FROM

(ooxml, embedded labels, table is Sheet1);

LET a = NoOfRows('temp');

NoConcatenate

Final:

LOAD

Resident temp Where RecNo()=$(a);

DROP Table temp;

Note: Try RecNo() unlike rowno() in the post you read.

Re: load just last row from excel

Mon, 04 Sep 2017 06:24:33 GMT

i have 3 error

Field not found - <A>

temp:

LOAD

FROM

(ooxml, embedded labels, table is Sheet1)

Table not found error

Table 'temp' not found

NoConcatenate

Final:

LOAD

Resident temp Where recno()=

Table not found

DROP TABLES statement

please send edited file

thanks

Re: load just last row from excel

Mon, 04 Sep 2017 06:39:12 GMT

i change a,b,c,d to * and its ok

thankyou