We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Rename Excel File Based on Current Quarter

Trevort
7 - Meteor

Hi All, Looking for a way to rename an excel file automatically based on the current quarter/year. The file name is "123" and if it is Q1 for example id like the file to say "123 Q1 2025"

3 REPLIES 3
abacon
12 - Quasar

@Trevort What you need is a field that is dynamically creating the quarter (see the screenshot), then follow the instructions on the thread below. However, you will use the 'change entire file path to do this. If it needs to go to a specific directory location, not always in the same location as the workflow, define the full path of the output file in the output name field.image.png' option.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Group-output-into-seperate-she...

 

Bacon

binuacs
21 - Polaris

@Trevort similar to @abacon method but used different formula for finding the quarter

image.png

Qiu
21 - Polaris
21 - Polaris

@Trevort 
I will go with the approach @abacon  as well. 😁

Labels
Top Solution Authors