Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Naming Output tabs based on daily change to data

Rob48
8 - Asteroid

Hello, I run a workflow daily that feeds 4 separate tabs into an existing excel output file.  Each of the tabs has the same format and the last column in each tab will have a different output and that day's date, as below:

 

Tab 1Tab 2Tab 3Tab 4
Last Column NameLast Column NameLast Column NameLast Column Name
ABCD 22May EFGH 22MayIJKL 22MayMNOP 22May
ABCD 22May EFGH 22MayIJKL 22MayMNOP 22May
ABCD 22May EFGH 22MayIJKL 22MayMNOP 22May
ABCD 22May EFGH 22MayIJKL 22MayMNOP 22May
ABCD 22May EFGH 22MayIJKL 22MayMNOP 22May
ABCD 22May EFGH 22MayIJKL 22MayMNOP 22May

 

 

I want to set up the flow so that the 4 new tabs I send into the output file are named "ABCD 22May" "EFGH 22May" etc.  

 

Right now I'm doing this manually by selecting "Create New Sheet" in the output options in the output data configuration box, and then in the "Write to File or Database" section I manually changing the name of the existing tabs from the previous day's tab names to the new name I want.  Meaning, I will change the existing tab named "ABCD 21May" in the output file to "ABCD 22May"

 

How do I get my new tabs to name themselves automatically?

 

 

Thanks for any help you can provide.

2 REPLIES 2
binuacs
20 - Arcturus

@Rob48 One way of doing this 

binuacs_0-1684763144760.png

 

Rob48
8 - Asteroid

thanks, that worked!

Labels