Filling up "buckets" based on bucket constraints

Question

Hi Alteryx Community,

Need your assistance to assign the SKUs to the corresponding Load ID based on load constraints:

I have attempted below; however, I believe there are other smarter ways to go about achieving the intended output 😀

Thank you

PERIODDAYSVENDOR_NAMEmaximum PALLETS per loadmaximum SKUs per loadLoad IDWeek 1MonAPPLE2251Week 1TueAPPLE2252Week 1TueAPPLE2253Week 1WedAPPLE2254Week 1ThuAPPLE22510Week 1ThuCARROTS22511Week 1ThuCARROTS22512Week 1ThuCARROTS22513Week 1ThuCARROTS22514Week 1ThuCARROTS22515Week 1ThuCARROTS22516Week 1ThuAPPLE22517Week 1FriAPPLE22518Week 1FriAPPLE22519Week 1FriAPPLE22520WEEK 6WedCOCA COLA7724WEEK 7WedCOCA COLA3325WEEK 8WedCOCA COLA22626WEEK 9MonCOCA COLA22627WEEK 10TueCOCA COLA6228WEEK 11ThuCOCA COLA22729

SKUsvendorPALLETS4574634APPLE204574635APPLE54574919APPLE44614650APPLE64615970APPLE94616112APPLE104616484APPLE64616564APPLE88211473APPLE18211586CARROTS203811906CARROTS53938736CARROTS44230884CARROTS64460625CARROTS94722460CARROTS104868589CARROTS504868590CARROTS64969939COCA COLA104970122COCA COLA204970155COCA COLA54973641COCA COLA4

YLYONG · Answer

impressive! is there another way around besides using batch macros, it may be as perfect, but still works?

ShankerV · Answer

Hi @YLYONG

If you are expecting output similar to the below.

PERIODDAYSVENDOR_NAMEmaximum PALLETS per loadmaximum SKUs per loadLoad IDSKUsWeek 1MonAPPLE22514574634Week 1TueAPPLE22524574635, 4574919, 4614650Week 1TueAPPLE22534615970, 4616112Week 1WedAPPLE22544616484, 4616564, 8211473Week 1ThuAPPLE22510 Week 1ThuCARROTS22511 Week 1ThuCARROTS22512 Week 1ThuCARROTS22513 Week 1ThuCARROTS22514 Week 1ThuCARROTS22515 Week 1ThuCARROTS22516 Week 1ThuAPPLE22517 Week 1FriAPPLE22518 Week 1FriAPPLE22519 Week 1FriAPPLE22520 WEEK 6WedCOCA COLA7724 WEEK 7WedCOCA COLA3325 WEEK 8WedCOCA COLA22626 WEEK 9MonCOCA COLA22627 WEEK 10TueCOCA COLA6228 WEEK 11ThuCOCA COLA22729

It can be achieved with the help of Batch Macros,

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

If you believe this post it helpful please like it.

Also please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

YLYONG · Answer

@ShankerV

here is it: the expected output is the Load ID against each SKU

SKUsvendorPALLETSEXPECTED OUTPUT: Load ID4574634APPLE2014574635APPLE524574919APPLE424614650APPLE634615970APPLE944616112APPLE1044616484APPLE634616564APPLE828211473APPLE118211586CARROTS20113811906CARROTS5123938736CARROTS4124230884CARROTS6124460625CARROTS9134722460CARROTS10134868589CARROTS5014,15,164868590CARROTS6124969939COCA COLA10244970122COCA COLA20254970155COCA COLA5244973641COCA COLA4265067712COCA COLA6245101424COCA COLA9265226408COCA COLA10275764614COCA COLA526