Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Linear Optimization (LP) Modeling

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
4 Comments
JCR
Alteryx Alumni (Retired)
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
5 - Atom
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
7 - Meteor
Could you please share an example on lpsolve. I'm not being able to find how to go about it.
Atabarezz
13 - Pulsar

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...Smiley Happy