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
Clever_Anjos
Employee
Employee

What do you mean by "specific row"?

3rd one for example?

Or

where A column = a value?

Not applicable
Author

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.

Anonymous
Not applicable
Author

Use where condition while reading the file like this?

Load

Name,

Address,

Mobile

From ExcelFile

where

Name like 'Hema*'

or

Name like '*Hema*'

or

Name like '*Hema';


Hope this will help!!

Digvijay_Singh

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

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

load the excel file and give the as it follows

where column name ='Hema'

jagan
Luminary Alumni
Luminary Alumni

HI

Try this where condition

LOAD

*

FROM ExcelFile

WHERE  RowNo() <= 3;

Anonymous
Not applicable
Author

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;

tamilarasu
Champion
Champion

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 ;