Excel Solver and Alteryx

Question

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?

this is how it looks in excel.

Thank you.

Mahmoud Alsaleh

Malsadeh · Answer

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

Yoshiro_Fujimori · Answer

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/306117

Good luck.