Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Constraints in Optimization tool

fcobosmolina
6 - Meteoroid

Hello community!

 

 

I have a question regarding the type of constraints you can set up in the Optimization tool.

 

 

You  can see in the picture a matrix 6x6 on the right side and on the left side a matrix with a representation of the output from the optimization tool:

 

fcobosmolina_0-1613046312160.png

 

 

 

On the following pictures you can see how I write the LHS and the RHS of the constraints, for making sure there is only one element per row/column:

 

fcobosmolina_1-1613046391927.png             fcobosmolina_2-1613046518854.png

 

This constraint is measuring that the sum of all the elements is lower or equal to 1 in each column and row. 

 

My questions is: can we put somehow a constraint that instead of a sum is considering the multiplication of the values in each row/column?

 

 

Thanks for your help!

 

 

 

Best, 

Fran

 

 

 

2 REPLIES 2
EricWe
Alteryx
Alteryx

Hi @fcobosmolina

 

Constraints can be an equality or inequality formula rather than a set value. Upper and lower bounds limits can also be entered as a formula. There is a recorded training session that may be helpful: Prescriptive Optimization. Constraints and bounds are added starting in about minute 33 of the video, and the example is attached to the article.

fcobosmolina
6 - Meteoroid

Thanks a lot for the answer, I will take a look into the training session. 

Labels