Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To read specific row in xls file.

hi,

I'm very new to Qlikview, I need to load multiple xls files in that need to read a specific row, could anyone of help me on this please.

thanks,

Hema

14 Replies
Digvijay_Singh

You can try this as well -

table:

first 3 LOAD

     *

from sometable;

Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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
Author

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?