Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.

Output Issue

Highlighted
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 -

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

 

Output -

There should be 2

NameAmountType
ABC Co.152Initial

 

NameAmountType
ABC Co.125Variation

 

Please Help

Highlighted
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,

 

Jean-Baptiste

Highlighted
Alteryx
Alteryx

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

 

Thanks

Will

Labels