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 am struggling to understand how to use a field to alter the output filename.
I have generated a field that I would like to use for the filename when writing my output Excel workbook.
For example, I am importing Input.xlsx and want the Output Data tool to write to 1118 Input.xlsx (which is the value of a field) to a sheet named New Sheet. Is this possible?
I have tried all the options under Take File/Table Name From Field but the best I can do is change the name of the sheet, not the file itself. How would I accomplish this?
On a related note, I would also need to somehow extract just the path of the input file; not sure how to do that either. If I could get that, I could just build the complete path & filename myself, I think. Would that also allow me to set the sheet name using |||'New Sheet'$?