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 -

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