Alteryx Designer Desktop Discussions

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

Increment sheet name by 1

wsang
6 - Meteoroid

We are building a workflow which should do the following: 
1.  Every time we run the workflow The Column named "Version" will increment by 1.
 note: that the version starts with 0

2. Tab name- Every time the version increments it should add another tab in excel named sheet_1
Example: If I have a sheet name "Sheet_" and when i run the workflow it should create a new sheet named "Sheet_v1"
3. Condition: This should only happen when you run the workflow within the same day.

 

 Any tips and help will be highly appreciated. Thank you so much.

 

 

3 REPLIES 3
dsaidov
5 - Atom

The attached workflow is a quick flow that might give you an idea of what to do. The question is what do you want to do the next day with the file? Is it getting removed or what? But that is for you to decide and potentially to add. 

caltang
17 - Castor
17 - Castor

You can try this: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Count-Workflow-Runs/td-p/74543...

 

A different take on your question, but in the same lines of thought.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
wsang
6 - Meteoroid

Thank you so much. This is the solution im looking for. 

Labels