i am trying to add the Area name to the filename and it will not work as an .xlsx file but it will work as a .csv file. I would prefer to have an .xlsx file, however, i am more interested and curious to find out why this works for one file type and not the other when the options to do this are available for both on the Output Data Configuration screen.
Solved! Go to Solution.
@cstafford It seems to work for .xlsx file types. See below.
How does the AREA column look like? Do you have a screenshot or a sample workflow that you can share?
"File/Table Name" refers to the object that is storing a single data set. For a database, it's a table. For most file sources, that is the file name. For Excel, that means the individual worksheet. The only way I've found to specify a file name for an excel output is to replace the entire path. This can be tricky because unless you have a column that contains the full path you can't be sure exactly where the file will be saved. Also, if the sheet name you want to create in the new file isn't specified (by adding "|||" followed by the sheet name), you'll get an error. I've attached an example.
In the example, the Input Data tool is set to save the entire file path, then a formula modifies the path name. In the Output Data tool, the "Take File/Table Name From Field" option is set to "Change the Entire File Path."
This will work. Thank you.
This worked perfect for me... the only modification I made was the input tool before the formula was actually a text input where I copied and pasted the destination file path location in. Otherwise the formula piece of you example worked perfectly and all I had to do was swap out the field I wanted (which I dynamically generated to be Report Name - XX/XX/XX
Thanks for the tip!