Start your journey with Alteryx Machine Learning - Take our Interactive Lesson today!

Alteryx Machine Learning Discussions

Find answers, ask questions, and share expertise about Alteryx Machine Learning.
Getting Started

Start your learning journey with Alteryx Machine Learning Interactive Lessons

Go to Lessons

Optimization Tool Issue

Divyajyothi7
8 - Asteroid

Hi Team

 

I'm facing issue with the optimization tool. I have attached the workflow without optimization tool. I have two datasets 1 and 2 .

In the second dataset . I'm getting the expected results . However with the first dataset, I'm facing the issue.

 

Logic for this workflow :

 

 
Logic -1   Logic - 2  
100.05 1:M 40.67 M:M
-50.45   67.78  
-50.60   -30.55  
30.99   -44.33  
    -33.57  
    60.77  

 

As shown in the amounts are getting written off based on 1:M and M:M (original data is scrambled).

 

@PhilipMannering 

 

note : workflow attached does not have optimization tool due to my trial license

Pictures have been attached

 

 

 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

What is the objective here?

What are you trying to achieve?

The "Logic for this workflow" is just a list of numbers.

What does "1:M" and "M:M" mean?

Divyajyothi7
8 - Asteroid

objective is to balance positive and negative where sum is equal to zero.

for Example :

 

Input :

 

rowAmount
1101.05
2-50.45
3-50.6
430.99
540.67
667.78
7-30.55
8-44.33
9-33.57
1060.77

 

Expected output :

rowAmounttype
1101.05balanced
2-50.45balanced
3-50.6balanced
430.99 
540.67balanced
667.78balanced
7-30.55balanced
8-44.33balanced
9-33.57balanced
1060.77 

 

As shown in the expected output  from row 1 to 2 sum is zero ( balance is done based on 1 : M combination , 1 positive and M negatives)
and from row 5 to 9 sum is zero ( balance is done based on M : M combination , Many positives and Many negatives)
I need to build a workflow which balances amount with combination 

 

In the uploaded Excel, there are two datasets have been attached
Data set -2 is balancing correctly, giving the sum of amounts is zero
when i used same logic for data set-1, the sum of amounts is not equal to zero

 

is it possible to balance amounts without optimization tool