TO Shipment Splitter
The TO Shipment Splitter tool splits shipments that are currently too large to fit on a feasible asset. It creates new shipments with quantity/weight/volume equal to full asset load equivalents plus any leftover quantity/weight/volume. If a shipment is oversized for all feasible asset types, the tool identifies the asset with the least constraining unit of measure to create the shipments.
In the Shipments table:
- Oversized shipments have their Name values appended with “_OriginalOversized”. The Status of these shipments is set to Exclude.
- New shipments have name values appended with “_0”, “_1”, etc.
Additionally, the tool populates information in the Shipment Notes, identifying the original and split shipments.

- Select Model > Model Transformations.
- Select TO Shipment Splitter.
- Select how the following options should be populated:
- Server Name – By default, this uses the current SQL Server LocalDB instance name (typically “GURU-<username>”).
- Expansion Scenario – This is the name of the scenario you want to verify. The scenario will be expanded in order to perform verification.
- When you run the transformation, you can accept the default values for parameters that accept edit when run, or enter a new value.
- Click Run.
- Click Yes to reload the current model.
In the Shipments table, oversized shipments have their Name values appended with “_OriginalOversized”. The Status of these shipments is set to Exclude. The new shipments have name values appended with “_0”, “_1”, etc.
Last modified: Wednesday May 15, 2024