Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable


Hi guys

I have to pull the data from the excel sheet ... but i don't want the rows from 11 to 211..... how to do it using transformation ....

Thanks in Advance

2 Replies
Not applicable

Re: Transformation

Hi Manish,

while picking teh excel file click the  Enable transformation step >> Garbage >>Conditional Delete>>Range

and then select the "From" and "To" buttons to specify ypor range.


Re: Transformation

... or just add a Where clause on your load statement:

Load ... From ... Where recno()<11 or recno()>211 ;


Community Browser