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.
Ah yes, ok so once you have your Fiscal Year column, you can use that as a value to split up your results into different tabs in an Excel workbook (check the box in the Output tool to Change File/Table Name and then select your Fiscal Year field... this will create a tab called "2018", "2019", etc. based on the results of that formula). If you want them in separate files altogether, you just need an additional formula that creates a filename (will need full filepath where you want the results output) and then you can choose the option to Replace Entire Filepath in your output tool, instead of Change File/Table Name.
That helps significantly. I am going to have to separate them into different files because i will using them later on in the workflow. Do you know what additional formula i would need? Sorry never have created a new output based on a field.
I also was getting an error (when i ran it a second time, first time worked) of "Unable to Open archive for zipping" when i selected Change File/Table Name
After you create your Fiscal Year field, add another formula called "Filename" and do something like the following:
"C:\Folder Location\Fiscal Year " + ToString([Fiscal Year]) + " Output.xlsx|||Sheet1"
In this example, the C:\Folder Location part would be whatever filepath is needed to get to the folder where you want it saved... and then you can create the name of your file, using the Fiscal Year as part of it (may need to use ToString to convert your year to text, depending on the data type)... and then make sure you end it with ||| three pipe delimiters & a sheet name for Excel.