community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Quickly Restart Tool ID Numbering/Control Order of Tool Execution

Asteroid

Hi,

 

Does anyone know how to restart the tool ID numbering in an Alteryx workflow?  I have completed a workflow (with upwards of 50 tools) but the tool IDs do not match the execution order I would like. See example below. Thanks!

 

 

 

Capture.PNG

Alteryx Certified Partner
Alteryx Certified Partner

@poles1c,

 

Tool IDs are assigned as they are dropped onto the canvas.  Order of execution is not guaranteed by the order of the ID.  What business problem is it that you are trying to solve for? 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

Hi,

 

Thank you for your quick response. I have two goals:

 

1) I am using a run command tool to pull an FTP file. I want to make sure the file is pulled (therefore refreshing the data) before the workflow begins to process.

2) I am using another run command tool (in the same workflow) to kick off another work flow. I want to make sure the next workflow is not kicked off until the current workflow is finshed processing.

 

pull file ("refresh data")--->process "refreshed" data ----> kick off workflow (which uses processed data)

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

If I am going to run CONTAINER of logic #1 and want it to be complete before I progress, I cheat.   I summarize the data and count records.  I then append that record count to the incoming data.  Using this method, you can't get a count until the FTP is complete.  When you append the count to the FTP data, you don't actually have to append the field.  Uncheck it.

 

Now your FTP is done and you can begin your workflow.

 

Now you can use an EVENT (workflow configuration).  Set it to execute a RUN Command on successful completion of your workflow.  Does that work for you?

 

The Events tab sets different settings specific to the run. The user can receive alerts via email or can execute another process around the workflow event.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

This works! Thanks!

Labels