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

Order of the message workflow

CDON
7 - Meteor

Hello,

 

I am wandering if there is a logic in the message results of the workflow once I have run it.

 

I have 4 input files (A1-A2-A3-A4), some formulas, cleansing, and other tools, and then I have added another input file (B).

I run the workflow

In the result message part (the part below the workflow), I see in the first line that input file B and then below after some message the input files A1, A2, A3 and A4.

 

Does it means that Alteryx treated the information in a random way ?

 

Thank you for your input

8 REPLIES 8
carlosteixeira
15 - Aurora
15 - Aurora

The order in which messages appear follow executions.

It will always start execution by the smaller IDTOOL.

In the image below you will see 4 TOOLS.

Input Data (ID1)
Browse (ID4)
Input Text (ID3)
Browse (ID5)

As it starts execution by ID1 it terminates ID1 and shows ID4 (BROWSE)

And then it starts ID3 and shows ID4 (BROWSE)
Pic 1

clipboard_image_0.png

 

If you delete ID 1 and create another Input Data (ID6) it will reverse the order of execution.
Pic 2

clipboard_image_1.png

Carlos A Teixeira
CharlieS
17 - Castor
17 - Castor

The logic that controls the order of operations has a number of influencing variables. Of course, the tool connections will influence order, but what if there are 5 input tools? In that case, the ToolID # typically controls the order of input. 

 

You can check to see if this is the case by checking the Tool ID of each tool (Configuration window > Annotation) or in the results window: there will be a number in parenthesis for each line (like "Input (5)" ). See if these input tools follow an ascending numeric order. 

CDON
7 - Meteor

Aie !

i had to delete my first Input tool and recreate a new one after having built the workflow.

So the IDtool is bigger than the 2nd Input data tool, therefore I understand it is done after.

That's logic !

So how can I change the IDtool number please ?

The workflow has to start with my 4 input datas.

 

By the way, I had to delete it because the tips to do : Export *.xls in the formula, for the 4 same exports with same names didn't work. It only ran 2 files out of 4

;-(

 

Thanks for your advice

CDON
7 - Meteor

Thanks for your explanation, which confirm the answer I received from Carlos.

I am having other pb now with the IDnumber not in the right order ;-(

CharlieS
17 - Castor
17 - Castor

Tool ID numbers are assigned when a tool is added to the canvas. So if you want to force something to the end, cut and paste it. The pasted tool will be treated as a new tool and get the next tool ID available. If you want a tool to be first, cut and paste everything else. You can also use Block Until Done tools (in the Developer category). 

 

The point is that the tool ID doesn't matter because the Alteryx engine will make sure the workflow is processed in the correct order in accordance with the tool connections. If it's defaulting to tool ID values, then it doesn't matter which one is processed first. 

CDON
7 - Meteor

Hi, did it ever happen to you that even if the icon are in the right order (with the right increasing number) the workflow starts with tools 75 and then tool 1 ?

Would it be because I have moved the file from a server to my desktop ?

 

All is mixed up now....I don't understand how it happened.

Do I have to rebuilt it from scratch ?

 

Rgds,

 

CDON
7 - Meteor

Hi CarlosTeixeira2005,

 

I have understood the importance of the tools ID numbers, so I have rebuilt the workflow knowing that.

BUT once I have added Input Data tools almost at the end of the workflow, those Input Data tools come first when I ran the workflow.

Then, the workflow follows the ID numbers.

 

Do you know why and how to fix this please ?

 

Thanks for your advice,

 

Regards,

carlosteixeira
15 - Aurora
15 - Aurora

Hi@CDON , how are you?

 

I don´t know why. Can you share your workflow? And let me know how is your sequence at tools are you need.

 

I can take a look and try to help.


Best regards

 

Carlos A Teixeira
Labels