Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: To read specific row in xls file.

What do you mean by "specific row"?

3rd one for example?

Or

where A column = a value?

Not applicable

Re: To read specific row in xls file.

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.

balrajahlawat
Esteemed Contributor

Re: To read specific row in xls file.

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!!

Highlighted
Digvijay_Singh
Honored Contributor III

Re: To read specific row in xls file.

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

MVP
MVP

Re: To read specific row in xls file.

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.

vsudhakar
Contributor III

Re: To read specific row in xls file.

load the excel file and give the as it follows

where column name ='Hema'

MVP
MVP

Re: To read specific row in xls file.

HI

Try this where condition

LOAD

*

FROM ExcelFile

WHERE  RowNo() <= 3;

balrajahlawat
Esteemed Contributor

Re: To read specific row in xls file.

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.

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 ;