Finding Solution based on multiple constraints

[yuganda]

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

[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?

[fmvizcaino · Accepted solution]

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