output to multiple excel tabs

[rking]

Pulling data for multiple locations and want to segregate output by location.  I am getting error message file is in use.  Have output options - Overwrite sheet or range.  Any suggestions?

[DanielG]

@rking  -- Check out this simple example for ideas.

[DanielG]

Create a path field with a formula tool for which data needs to go to which sheet, then replace the entire path (way at the bottom of the output tool config).  😊

[DanielG]

The "template" path in the "Write to File or Database" can be anything really, as it will never actually be used in the output of the file.  For simplicity sake, I kept the file name the same but you can see I named the sheet 400 to show Sheet 400 doesnt get created in the output