Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
Write like
Load * from Location
Where RowNo( ) >= 10 and Rowno( ) <= 25;
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;
Thank you very much, this works a treat!!!
Thanks I am very happy that it working
Regards