Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Assigning Delivery Orders

Ashley2
8 - Asteroid

Hi All,

 

I have various delivery trucks each which can take the same load (for example 10 orders), data is listed similar to below

 

TruckLoad
110
210
310
410
510
610
710

 

All orders must be assigned to a delivery truck, some have already been automatically assigned. The remaining orders must be assigned to a delivery truck with Order Priority in Descending order (i.e. High -> Medium -> Low) and Order No Ascending. 

 

Order NoVulnerable CustomerPriorityAssigned Truck
1TrueHigh1
2TrueHigh7
3FalseMedium 
4FalseLow 
5FalseLow 
6TrueHigh1
7FalseLow 
8FalseLow 
9FalseLow 
10TrueHigh1
11FalseMedium 
12FalseLow 
13FalseLow 

 

 

This is just a condensed example, the actual data contains hundreds of cases

 

Open to ideas on the best way to allocate this🙂

 

Thank you in advance!

3 REPLIES 3
AMansour
11 - Bolide

Hi @Ashley2 

 

I'll go for a batch macro and with each iteration, I'll recalculate the remained load capability for each Truck.

 

your parameter control will be the your order listed sorted by Priority and Order N.

 

Hope that's will help you

OllieClarke
15 - Aurora
15 - Aurora

Hi @Ashley2 here's a way which doesn't require a macro

OllieClarke_0-1585844988951.png

 

Ashley2
8 - Asteroid

Thanks @OllieClarke that worked perfectly!

First time seeing dynamic replace very handy tool!

Labels