topic Re: Transformation in QlikView

Transformation

Mon, 09 Jul 2012 06:27:59 GMT

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

Mon, 09 Jul 2012 06:48:30 GMT

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.

hic — Tue, 10 Jul 2012 17:34:14 GMT

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

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

HIC