Reading specific rows from Excel

[#1]

Hello,

I am using qlikview and still trying to get my head around the coding but have a question that someone might be able to help with.

I have an excel file that is loaded into qlikview, however I would like to code it in a way to be able to read specific rows. Eg:

The data I am interested is in an excel file called tester.xls and I only want to read rows 10 to 25 where the data I need resided. Is there a way of doing this?

Many thanks in advance for your help.

regards,

Roberto

[sbaldwin]

Hi if there is a condition that evaluates to true when you want to import the row and false otherwise you could use that in the file import wizard eg a certain column is populated? otherwise you could load all the data adding a rowno() field then resedent load into a new table where the rowno is between 10 and 25?

Thanks

Steve

[its_anandrjs]

Write like

Load * from Location

Where RowNo( ) >= 10 and Rowno( ) <= 25;

[its_anandrjs · Accepted solution]

Another way is

Write like

Table1:

Load *,Rowno() as Rid from Location;

Noconcatenate

Final:

Load * from Location

Where Rid >= 10 and Rid <= 25;

Drop Table Table1;

Or

Load * from Location

Where RowNo( ) >= 10 and Rowno( ) <= 25;

[#5]

Thank you very much, this works a treat!!!

[its_anandrjs]

Thanks I am very happy that it working

Regards