lovebau
November 22, 2024, 5:19pm
1
Hi,
I would want to save the individual files for CLOSE IN SYSTEM YES to one folder and CLOSE IN SYSTEM NO to a separate folder as well. Can someone help me or guide me on how I could do this?
takbb
November 22, 2024, 9:12pm
3
Hi @lovebau , you should be able to adapt the idea from this thread.
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.
[image]
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 …
Basically look at the part with the group loop, and where it mentions commodity/category, this is equivalent of your “close in system”.
You might want to replace excel writer with csv writer or whatever file output format you want.
