Quickly Restart Tool ID Numbering/Control Order of Tool Execution

[poles1c]

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!

[MarqueeCrew]

@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? 

[poles1c]

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)

[MarqueeCrew · Accepted solution]

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.

Enable Events Checkbox: Checking this box enables the use of events.

1. To add an Event, click the Add button. There is no limit to how many events you can set up per workflow run.

2. Events can be organized utilizing the Up, Down, and Delete buttons.

There are two types of events, Run Command and Send Email.

Run Command: Another process is run based on the parameter selected around the workflow event.

Send Email: An email is sent based on the parameters selected around the workflow event.

[poles1c]

This works! Thanks!