Identifying Items to Fulfill (100% Complete) the Most Baskets

Hey All,

Looking for some advice on how to handle this problem.

I am needing to identify the most optimal set of items that will 100% fulfill the most baskets. Each basket has its own unique "itemset" or "combination of items".. With this data, I am needing to identify the "itemsets" that fulfill the most baskets based on the input # of unique items we are looking to pull out. For example, if I am looking to identify only 10 items that fulfill the most baskets, I must select "itemsets" that do not exceed the unique combination of 10 items in summary.

My raw data is attached.

Any and all help is greatly appreciated!

SAMPLE DATASET.csv

Prescriptive Analytics

Accepted answers

All comments

daltonhuneycutt

The attached data is sample data. My dataset is much larger. Thanks.

CarliE

Hi @daltonhuneycutt ,

I just want to clarify. Are you trying to see which item is used the most out within the different sets? Or if a set has less than 10 items, you want to look at it?

I attached a workflow with both cases

If not, can you explain what you mean a little more? Or provide an expected output based on your sample data?

If this solved your problem, please make sure to mark as a solution.

Thanks,

Identifying Items to Fulfill (100% Complete) the Most Baskets.yxzp

daltonhuneycutt

Hey,

Thanks for your quick response! I am unable to import your model because I am on a older version of alteryx.

To keep it simple, I'm just needing to identify ten items that complete the most number of baskets within these 15 baskets. For example, is there a ten item combination that fills 100% 6 of these 15 baskets? If so, is that the best outcome possible? Or is there another 10 itemset that fills more baskets? I also need to be able to change that limiting factor of 10 items to possibly 7 if I am only willing to accommodate for 7 items.

daltonhuneycutt

I would like to open your posted model though. Is there a way to get around us operating on different alteryx versions?

Thank you!

atcodedog05

Hi @daltonhuneycutt

You can try this guide https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703