SAVING FILES IN 2 SEPARATE FOLDERS

[lovebau]

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]

Hi @lovebau, you should be able to adapt the idea from this thread.

Excel Reader is not reading files individually

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.