Dynamic row limit

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 — Apr 10, 2018 08:04AM UTC

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.