Hi,
Say, I have below table (originally 10000+ rows) where I need to assign category number based on Item, Product columns and also below conditions. Can someone please help me on this
Each product has multiple items and each item has multiple products
Conditions:
Rows with same product number should be under same category number. Cannot break product into multiple categories
Similar item rows are also to be under same category ie., partial Items ("Item" Column) in a category are as minimal as possible
Ideal number of rows in each category should be <=150
Say, I have below table (originally 10000+ rows) where I need to assign category number based on Item, Product columns and also below conditions. Can someone please help me on this
Each product has multiple items and each item has multiple products
Conditions:
Rows with same product number should be under same category number. Cannot break product into multiple categories
Similar item rows are also to be under same category ie., partial Items ("Item" Column) in a category are as minimal as possible
Ideal number of rows in each category should be <=150
Item | Product | Category (To be filled) |
Item 1 | Product 1 | Cat 1 |
Item 2 | Product 1 | Cat 1 |
Item 3 | Product 1 | Cat 1 |
Item 1 | Product 2 | Cat 1 |
Item 1 | Product 3 | Cat 1 |
Item 5 | Product 1 | Cat 1 |
Item 4 | Product 4 | Cat 2 |