Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Excel Row limit

i am using excel query component...i want to retreive particular row limit data only

(ex:from row 2 to 11)

how to give particular limit in excel data???



Thanks
Ganesh

4 Community Answers

Matillion Agent  

Paul Johnson —

Hi Ganesh,

You can use the Cell Range property of the Excel Query component.

By default the whole worksheet is considered. However, you may optionally specify a range of cells instead. For example, A5:E100 would only consider rows 5-100 in columns A-E. Wildcards () are also supported, for example A5:E would consider columns A-E and rows 5 onwards.

More information can be found at the bottom of this page

Regards,
Paul


Ganesh Pitchai —

Hi i got a error..."code!=0 query compilation failed".... And try to used advanced component using sql query particular column value is null....


Tha


Ganesh Pitchai —

Hi i got a error..."code!=0 query compilation failed".... And try to used advanced component using sql query particular column value is null....


Thanks
Ganesh


Matillion Agent  

Ian Funnell —

Hi Ganesh,

Please can you email an export of your job to support@matillion.com

Best regards,
Ian

Post Your Community Answer

To add an answer please login