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
Laura Malins —
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.