topic Re: To read specific row in xls file. in QlikView

To read specific row in xls file.

Wed, 02 Mar 2016 16:05:14 GMT

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

Re: To read specific row in xls file.

Clever_Anjos — Wed, 02 Mar 2016 16:36:57 GMT

What do you mean by "specific row"?

3rd one for example?

where A column = a value?

Re: To read specific row in xls file.

Thu, 03 Mar 2016 06:23:52 GMT

Thanks for the reply

Yes, In the file, row has data’s in row 1 row2 and row 3, in that I need only row 3 data’s in the Dashboard, I’m not much familiar in scripting so seeking for help.

Re: To read specific row in xls file.

Anonymous — Thu, 03 Mar 2016 06:27:42 GMT

Use where condition while reading the file like this?

Load

Name,

Address,

Mobile

From ExcelFile

where

Name like 'Hema*'

Name like '*Hema*'

Name like '*Hema';

Hope this will help!!

Re: To read specific row in xls file.

Digvijay_Singh — Thu, 03 Mar 2016 06:30:31 GMT

Use Where clause to filter specific rows, you need to know the filter criteria to be put in where clause.

Re: To read specific row in xls file.

jagan — Thu, 03 Mar 2016 06:38:17 GMT

Hi,

While posting the question in community prepare sample data and attach it, so that it would be easier to understand and provide you the solution. This way you will get the answers quickly. Please check below link for getting successful answers

Qlik Community Tip: Posting Successful Discussion Threads

You can use where condition to filter the rows, or you can use RowNo() or RecNo() in the where condition.

WHERE RowNo() = 5;

Hope this helps you.

Regards,

Jagan.

Re: To read specific row in xls file.

Anonymous — Thu, 03 Mar 2016 06:40:09 GMT

load the excel file and give the as it follows

where column name ='Hema'

Re: To read specific row in xls file.

jagan — Thu, 03 Mar 2016 06:46:29 GMT

Try this where condition

LOAD

FROM ExcelFile

WHERE RowNo() <= 3;

Re: To read specific row in xls file.

Anonymous — Thu, 03 Mar 2016 06:49:07 GMT

Its seems you want to load only one column, is it?

I am assuming you are having excel file like this?

Row1, Row2, Row3

1 a aa

2 b vv

3 v bb

Now you want to load Row3 which is a column only?

Then simply write

Load

Row3

from YourExcelFile;

Re: To read specific row in xls file.

tamilarasu — Thu, 03 Mar 2016 06:50:02 GMT

If I understood you correctly, you want to load row no 3.? If so,

Load *

From

[Test.xlsx]

(ooxml, embedded labels, table is Sheet1) where RecNo()=3 ;

Re: To read specific row in xls file.

Digvijay_Singh — Thu, 03 Mar 2016 06:51:52 GMT

You can try this as well -

table:

first 3 LOAD

from sometable;

Re: To read specific row in xls file.

Thu, 03 Mar 2016 06:52:04 GMT

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

Re: To read specific row in xls file.

rwunderlich — Thu, 03 Mar 2016 06:53:32 GMT

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

Re: To read specific row in xls file.

Thu, 03 Mar 2016 08:36:27 GMT

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.

Hope it helps you..

Re: To read specific row in xls file.

Thu, 03 Mar 2016 12:40:42 GMT

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?