Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
... or just add a Where clause on your load statement:
Load ... From ... Where recno()<11 or recno()>211 ;
HIC