Order of Operations or "Pulling from an Ouput, that Was Modified in the Same Workflow"

[nbrightw]

Hey Everyone,

Mark from Marquee Crew provided me the steps to create this solution. Credit where credit is due. I was asked to explain this for some colleagues and thought it would be great to share with the community.

Scenario:
You need to output some data, then run an additional section of tools on that output which was modified (See the output and input “B”. The problem, is that Alteryx does not necessarily have an “order of operations” to process data. So your data runs like this  (The comment boxes show the order of operations):

What you would like is something like this:

Solution:
To do this, you have to join the tables by some means, late in the first table, and early in the second table. Using the count rows tool and the append tool. You can force this to occur.

The input at 5 cannot go further than 6 without getting data from four. 4 cannot get data without running the entire script of 1 through 3.

Note:
You will want to open the append tool, and remove “Count” as an option so it does not end up in your data.

I have attached a workflow that goes through this process. You will likely have to change the output and input files to make it work on your computer.