Linear Optimization (LP) Modeling

[rlandino]

Hello, 

I am not sure if this capability exists but I assume it does not.

We have a need to optimize a Linear Program (LP) model that consists of a system of equations and has both:
An objective function and a series of constraints. One of the software capabilities that SAS offers that currently
Alteryx does not have is this optimization capability. 

I am wondering if the capability is currently not available, is this capability in the Product Roadmap?

Thanks,

Ricardo

[JCR]

Hi Ricardo,

Alteryx includes the LP package lpsolve. See the following link for packages coming with v9.1 http://downloads.alteryx.com/Alteryx8.6.2/WebHelp/Alteryx_Predictive_Analytics.htm
Mathematical programming models of this type are something we have thought about including. However, they don’t lend themselves nicely to our existing GUI widgets. As a result, they are better handled using an R tool in an Alteryx workflow

Hope this helps
JC


 

[rlandino]

That's great to know, we'll be digging dipper into the Ipsolve LP package to better understand how to leverage this capability and apply it to one of our existing projects.

Thank you for the post JC.

Ricardo

[siddhartha_s]

Could you please share an example on lpsolve. I'm not being able to find how to go about it.

[Atabarezz]

Verison 10.6 seems it'll have very easy to use linear programming options... 

Download models from excel or load CPLEX format, solve in Alteryx, awesome...