topic Re: Reading specific rows from Excel in QlikView

Reading specific rows from Excel

Wed, 30 Apr 2014 13:17:45 GMT

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

Re: Reading specific rows from Excel

sbaldwin — Wed, 30 Apr 2014 13:21:35 GMT

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

Re: Reading specific rows from Excel

its_anandrjs — Wed, 30 Apr 2014 13:22:43 GMT

Write like

Load * from Location

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

Re: Reading specific rows from Excel

its_anandrjs — Wed, 30 Apr 2014 13:25:34 GMT

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;

Load * from Location

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

Re: Reading specific rows from Excel

Wed, 30 Apr 2014 13:35:20 GMT

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

Re: Reading specific rows from Excel

its_anandrjs — Wed, 30 Apr 2014 14:58:20 GMT

Thanks I am very happy that it working

Regards