Hi @jauntalan , @icfo is right that your loops are not properly completed, and in addition to that, I’m going to take a guess that the following structure is likely to be what you need.
I’m making an assumption here that all the Excel files have the same basic structure and so can all be read in, within a single loop.
In fact if all the Excel files have the same structure and are in a single folder, you can do away with the first loop altogether as Excel Reader can read all files in a folder, and you have this structure:
The Group Loop (grouped by your “commodity type”), rather than a Table Row to Variable Loop ensures that rows are passed to the Excel Writer in batches for the file to be written. I’m making an assumption that you will somehow be constructing the output path based on category, which is possibly what your original String Manipulation was for, but I’d do this as part of the loop using a String Manipulation (Variable), e.g. something like this:
and then that may get you to more or less where you want to be.