Optimisation tool - very simple issue

Question

Hello,

I am using the optimisation tool for a very simple equation, basically I am trying to figure out which combination of number adds to a total.

The tool works for the first combination of number but not the second, where I get the following error when I run the workflow (Error: Optimization (3): Tool #3: The R.exe exit code (3221225512) indicated an error.)
I can't seem to figure out the difference between the two optimization problems, and why one works and one doesn't.

Thank you for your help

optimisation tool - example.yxmd

StephV · Answer

Merci pour ta question ! Je suis sûre qu’elle aidera d’ autres utilisateurs. Cependant, ce forum est en langue française. Je t'invite donc à écrire de préférence en français ou si tu préfères l’anglais, tu peux poster ta question sur le Forum anglais. Merci à toi !

Si la réponse t'a aidé, n'hésite pas à l'"accepter comme solution", elle aidera surement d'autres utilisateurs 😉

WilliamR · Answer

Hello,

if you activate the macro message in the workflow (as the tool is an Alteryx Macro), you will get more information about the error:

"Info: Optimization (3): Tool #3: No quadratic elements detected. Defaulting to Rglpk_read_file."

Regards.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.