load just last row from excel

[#1]

hi

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

[tresesco]

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?

[#3]

my file is normal

please see 1.qvw file

[tresesco · Accepted solution]

Try like:

temp:

LOAD

          A,

          B,

          C,

          D

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.

[#5]

i have 3 error

1-

Field not found - <A>

temp:

LOAD

          A,

          B,

          C,

          D

FROM

(ooxml, embedded labels, table is Sheet1)

2-

Table not found error

Table 'temp' not found

NoConcatenate

Final:

LOAD

       *

Resident temp Where recno()=

3-

Table not found

DROP TABLES statement

please send edited file

thanks

[#6]

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

thankyou