topic Optimization Tool Issue in Alteryx Machine Learning Discussions

Optimization Tool Issue

Divyajyothi7 — Fri, 14 Jun 2024 14:08:59 GMT

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

Re: Optimization Tool Issue

philipmannering — Sat, 15 Jun 2024 14:02:07 GMT

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?

Re: Optimization Tool Issue

Divyajyothi7 — Sun, 16 Jun 2024 09:23:26 GMT

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

for Example :

Input :

row	Amount
1	101.05
2	-50.45
3	-50.6
4	30.99
5	40.67
6	67.78
7	-30.55
8	-44.33
9	-33.57
10	60.77

Expected output :

row	Amount	type
1	101.05	balanced
2	-50.45	balanced
3	-50.6	balanced
4	30.99
5	40.67	balanced
6	67.78	balanced
7	-30.55	balanced
8	-44.33	balanced
9	-33.57	balanced
10	60.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