Hey Everyone,
I am trying to configure the optimization tool in alteryx in a way that will allow me to solve the below problem.
I have over 1000 baskets/orders and within those baskets there are 352 unique items across all of the baskets. I am needing to find the most optimal 10 item "itemset" that completes the most baskets. At the moment, I am using baskets as my variables with a upper and lower bound of 0 and 1, so binary. As for the constraints, the only constraint that I have is the itemset must be no greater than 10 and it must be the most optimal itemset. I am trying to set this tool up as a mixed integer program while specifying the model as a matrices.
With that said, I have been unsuccessful at setting this tool up in a way that gives me the answer I am looking for. Any and all help will be greatly appreciated.
The sample data attached has the input data for anchor points O and A.