community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Optimization tool setup

Highlighted
Alteryx Certified Partner

 

Hi everyone!!

 

I just wondering if you can help me with the configuration of an optimization tool. I have this problem (schedulling), where:
 
i = 1, ..., 21 number of shifts (three shifts in one day - morning, afternoon and night) and
j = 1 ... 5 number of employees
 
As a test I was trying to do the optimization using the constraints (the ones in the red box)
 
Imagen2.png
 
And that will be something like this:
 
Constraint 1:
 
Employee1_Shift1 + Employee1_Shift2 + Employee1_Shift3 <= 1
Employee1_Shift2 + Employee1_Shift3 + Employee1_Shift4 <= 1
 
.... and so on .... to reach the shift 21 (That means that each employee can only work in one shift in one day)
 
 
Constraint 2:
 
Employee1_Shift1 + Employee2_Shift1 + Employee3_Shift1 + Employee4_Shift1 + Employee5_Shift1> = 1
Employee1_Shift2 + Employee2_Shift2 + Employee3_Shift2 + Employee4_Shift2 + Employee5_Shift2> = 1
 
... and so on .... to reach the shift 21 (That means that all shifts must have at least one employee on service)


But I don't get any result and I don't understand why. This is the error that I get
 
 
Imagen3.png
 
I hope you can help me!! I'm attaching my workflow
 
 
Thanks for all your help!
 
Labels