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 have searched far and wide so please forgive if this has been answered.
I have a workflow that outputs to 6 tabs in the same Excel spreadsheet. Every time I run it I have to update the "write to file or database" window for all 6 Output Data tools. Is it possible to assign a variable as the file name for each output data tool so I can update the variable which would update them all? The new file name cannot be derived from a column in the input files so I cannot grab it from there. Is there anyway to do this?
There's an option to use a field as the file name and to NOT keep it in the output. You should be able to control the file name in a single formula tool, join it to each set of data, and base the file name off of that:
You also might want to look into the Table/Layout/Render tools --- they allow you to output to multiple sheets all at the same time, rather than using multiple output data tools. May or may not help, depending on what you're trying to achieve.