Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Rename an excel file based on a cell in that file

Trevort
7 - Meteor

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

13 REPLIES 13
Trevort
7 - Meteor

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)

binuacs
21 - Polaris

@Trevort Replace F1 with the column name of the F4 cell

Trevort
7 - Meteor

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

Qiu
21 - Polaris
21 - Polaris

@Trevort 

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.

0521-Trevort.png

Labels
Top Solution Authors