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

Dynamic row limit

I have a multiple excel files loaded to redshift....

i need to set limit for every file till particular row of data...every file have different row count ...

In every file i need to set before particular row

(ex:before "TOTAL")...all files have this "total" data but different count limit!!!!

2 Community Answers

Matillion Agent  

Laura Malins —

Hi Ganesh

There are a couple of ways you could do this. The first option is that you can dynamically set the Cell Range in the Excel Query component. This can be set using variables. Or you could set the limit property with a variable in the component.

Or a final option would be to load all rows and exclude the TOTAL row in a Transformation job.

Thanks
Laura


Ganesh Pitchai —

Hi laura,

Thanks for ur support...I applied another condition using sql query..

Thanks
Ganesh

Post Your Community Answer

To add an answer please login