Append Suffix to File/Table Name .xlsx vs .csv

cstafford

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.

TonyA

"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." 

MultiFile.yxzp