Transformation

[#1]

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]

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]

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

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

HIC