Hi All, im looking to use alteryx to rename an excel file automatically based on a cell in that file. The file name is "123" and id like the name of the file to be renamed to what is found in cell F4 of the "Detail" sheet. Either renamed or the value in cell F4 to be appended to the end of my file name. I dont want to change any of the contents in the file, just rename it. Any help is appreciated I am new to alteryx
ErrorLink: Formula (2): https://knowledge.alteryx.com/index/s/article/Parse-Error-at-char-n-Unknown-variable-variable-name-E...Parse Error at char(67): Unknown variable "F1" (Expression #1)
@Trevort Replace F1 with the column name of the F4 cell
That works to rename the excel file, but id like to also have all of the data from the original file. There are around 10 sheets of data that I would like to remain in the renamed excel file. The only thing I want to change from the original file is the name. Sorry for any confusion and thanks for the help on this
My approach is to get the data from Sheet "Detail" then retrieve the data in Cell F4 and use a "Run Command" tool to change the file name outside of Alteryx without touching the Excel file itself.
User | Count |
---|---|
107 | |
85 | |
76 | |
54 | |
40 |