Is it possible for alteryx to find solutions based on certain criteria subject to certain constraints? For example, I am trying to determine which Furniture items were allocated to living rooms based on the total cost of the living room in that specific house. For example based on the below data, I can see that Furniture #855 and #898 were allocated to House #9718 living room. Is there a way for alteryx to compile a list of all the furniture that make up the respective House' Living Room cost? House #Cost of Living Room9718262461493520497728369763202477954099260254341633452 House #Furniture #Cost971867965697188551312971874753971889813129718858171897189157697185521101614963988061498503520614964123516149839314861499934909614965331946149707366361495472974497781048749777552769497757332649776654234977993283649779256314977684160197635191329763775409697639266639763732732779563749867795868463377956311700779597929082608652543260843233041637343954163687372941638133545

Finding Solution based on multiple constraints

Is it possible for alteryx to find solutions based on certain criteria subject to certain constraints? For example, I am trying to determine which Furniture items were allocated to living rooms based on the total cost of the living room in that specific house. For example based on the below data, I can see that Furniture #855 and #898 were allocated to House #9718 living room. Is there a way for alteryx to compile a list of all the furniture that make up the respective House' Living Room cost?

House #	Cost of Living Room
9718	2624
6149	3520
4977	2836
9763	2024
7795	4099
260	2543
4163	3452

House #	Furniture #	Cost
9718	679	656
9718	855	1312
9718	747	53
9718	898	1312
9718	858	1718
9718	915	76
9718	552	1101
6149	639	880
6149	850	3520
6149	641	2351
6149	839	3148
6149	993	4909
6149	653	3194
6149	707	3663
6149	547	2974
4977	810	487
4977	755	2769
4977	573	326
4977	665	423
4977	993	2836
4977	925	631
4977	684	1601
9763	519	132
9763	775	4096
9763	926	663
9763	732	732
7795	637	4986
7795	868	4633
7795	631	1700
7795	979	2908
260	865	2543
260	843	2330
4163	734	395
4163	687	3729
4163	813	3545

Prescriptive Analytics

Accepted answers

fmvizcaino

Hi @yuganda ,

I'm attaching an example here showing how to do it.

Since the optimization tool would not show all possible solutions, I've created manually all the possible cenarios considering 1 to 3 furnitures.

Let me know if this works for you.

Best,

Fernando Vizcaino

2020-04-24 Finding Solution based on multiple constraints.yxmd

All comments

fmvizcaino

Hi @yuganda ,

You can use the optimization tool, I think. You can select the constraints and the result you want to achieve, but it shows only one possible answer.

For your problem, it only contains a set of 2 furnitures or it can be unlimited number of ?

Best,

Fernando Vizcaino

yuganda

House #9718 contains two sets of furniture, but House#6149, contains only 1 Furniture#850 based on my data, so the number of furniture in the living room can be any sum of furniture that total to the cost of that house's living room. However, there may be cases where any subset of furniture cost do not agree to the total in the living room, in which case there is no solution. Can the optimization tool provide an output for all the House # that have a possible solution, or can it only do one House at a time?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703