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.

Network Optimization

danielrg
6 - Meteoroid

Dear Alteryx Community, 

 

I am hoping an optimization expert might be able to guide me in the right direction. I wish to move a model from Excel to Alteryx in order to increase the scale of decision variables and increase complexity.

 

This model requires shipments pass from a plant to a DC and then from that DC to a customer. Thus, there are balancing constraints (AI3:AI7) to ensure that whatever goes into a DC must also leave that DC, and also linking constraints (AG3:AG7) to ensure that in order to use a DC, it must be activated so the fixed cost is taken into account.

 

Is it required in the Alteryx optimization tool to use constraints to do the same balancing and linking as in Excel?


Thank you,

Daniel

1 REPLY 1
RishiK
Alteryx
Alteryx

@danielrg I think this previous post on the Community will be useful for you when we talk about constraints and the Optimisation Tool:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Optimisation-Tool-not-considering-cons...

 

as well as further info about the Optimisation tool in general:

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Optimization/ta-p/3061...

Labels