Chunk Loop - Chunks of varying size
Hi,
I’m trying to process a group of excel files to produce a single table containing all the relevant data. My issue is that the input files are not always the same number of rows long.
How do I set up a loop to deal with varying sizes of input? What I’d ideally want is some way of taking the output from the Excel Reader (the combined sheets), searching for a specific row, and splitting them according to that.