Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Output Issue

8 - Asteroid

Hi Alteryx Team


How do I gain an output in such a way that

Type should be the same(Right type - initial and Type - initial), as well as the Direction should be opposite (Right Direction - outgoing and Direction - incoming) then the Right Amount should add with the Amount (78+74 = 152)

If type is variation and doesn't have and Direction is Incoming or outgoing but doesn't have a link with a Right_Type Variation the Amount would be just 125


Input -

ABC Co.78InitialIncomingABC Co.74InitialOutgoing
ABC Co.125VariationIncomingABC Co.74InitialOutgoing


Output -

There should be 2

ABC Co.152Initial


ABC Co.125Variation


Please Help

Alteryx Certified Partner

Hi @stevegeorge ,


I attached a workflow with the solution I came up with. I'm not sure I correctly understood all the conditions but If not, you can customise the conditions within the formula tool.


Don't hesitate if you have questions or need more details.


Have a great day !


Kind regards,




Hi @stevegeorge 


I think that this can be achieved using a Formula tool and IF statements to build this logic.


It may require some adjustments as I am not sure if I fully understand your current problem, but the attached workflow should help with this.


Let me know if you have any questions