Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Digvijay_Singh
Honored Contributor III

Re: To read specific row in xls file.

You can try this as well -

table:

first 3 LOAD

     *

from sometable;

Not applicable

Re: To read specific row in xls file.

Thank you all for the response, got a correct solution.

Re: To read specific row in xls file.

To load just the 3rd row, you can add a where clause to the load like this

LOAD

     *

FROM myfile.xls

WHERE RecNo()=3

;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Highlighted
Not applicable

Re: To read specific row in xls file.

Hi,

If you have only 3 rows excluding headers in all the excel files. Use either of the below 2 approaches.

1. using transformation you can delete the unnecessary rows. For this use the below From statement for your load statement.

Test:

Load * FROM

(ooxml, embedded labels, table is Example, filters(

Remove(Row, Pos(Top, 3)),

Remove(Row, Pos(Top, 2))

));

2. When loading select the below setting shown in the image and rename the headers as you need.

. Option 2.JPG

Hope it helps you..

Not applicable

Re: To read specific row in xls file.

Hello everyone, To write loop condition

It is continued with my previous question, below is my xls sheet- need to read from row 83(UGTX1000) to 103 (till blank) and it also read the data’s in Purple color which is linked to row 83. The same thing has to be read in multiple xls sheets.

I used where condition but it only read row 83.

I know we can read my loop condition but don’t know much on that, may I know how to get the solution?