This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I put together a workflow that should demonstrate how you can output multiple files based on criteria. I used your example file as well as a similar one I created.
I used two input tools and a union. However, I recommend using a wildcard character in the input tool to bring in multiple files at once. (I did this so I could package the data with the workflow.)
Pay close attention to the configuration of the output tool (specifically the bottom part of it). This configuration allows you to write multiple output files by grouping o a specific field. In this case, the FileName.
@LukeG solution is very good and straightforward in simple cases. If you needed to keep the original formatting or other complex situations, @JoeS method of bat commands would be the standard way to go; however, @JosephSerpis had an interesting post about using blobs that would seem to work as well. I've modified @LukeG perfectly working solution to demonstrate the blob method which will maintain formatting.
Really I just thought @JosephSerpis blog was awesome and it would possibly solve your use case.