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!

[TRW]

I'm bumping up this old thread because I have a different problem.  I have taken over management of workflows with hundreds of tools, and often need to find tool where a particular field first appears.  I try to narrow down by only looking at a particular type of tool, but that doesn't help.  For example, I have over 50 Select tools where the field I'm looking for appears, and the ID order ranges from 853 (which appears at the end of the workflow) to  5716 (which is about halfway through the workflow.)

Is there any way to sort or rank the Tool Ids based on where they appear so I don't have to look at 50+ tools when searching for the first instance of a particular field?

[inDBeast]

Hey I'm not sure if you are still having trouble with this or not but you can accomplish this through the Find&Replace function. Just CTRL+F and search for the field you are looking for. The table of results can be sorted by clicking on the column header. In your case you would want to click on ID.