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.
If you have a file that you want to output to separate Excel files you can first create the desired file path with the Formula tool and then utilize the Output tool to change the entire path.
This example illustrates a file with records from different states, where we wish to create a separate file for the records belonging to each state.
With the Formula tool, create a string field that will contain the file path, where the path includes the field you’ll use as a part of the file name. Here we are using the State_Name field. “C: emp” is the path where your files will be saved to.
The field you are creating, and the field you are including as the variable path name (State_Name) have to be of a string type. If your variable path name field is not a string type then you can convert it with the TOSTRING function.
In the Output tool, select Change Entire File Path and select the newly created field. Uncheck Keep Field in Output so it won’t add as a field the path that was created with the Formula tool.
The Output tool will write separate Excel files, the name and path of the files are the ones created by the formula.