ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Excel Solver and Alteryx

Malsadeh
7 - Meteor

I use the solver excel to find a specific value among a set of data, but after I got introduced to Alteryx, I don't to open another Excel sheet.

These are the constraints I used in Excel Solver Parameters.

 

Please let me know If you can do it in Alteryx?

Malsadeh_0-1680738962370.png

this is how it looks in excel.

Malsadeh_1-1680739069182.png

 

Thank you.

Mahmoud Alsaleh

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @Malsadeh ,

If you are looking for solving optimization problems, you should consider using Optimization Tool.

This "Tool Mastery" arthicle would be a good start point.

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

 

Good luck.

Malsadeh
7 - Meteor

Thanks for advising. I have downloaded it and I hope I will be able to use it.

Labels
Top Solution Authors