Scripted simulation pipe
For Simulation models only, Scripted simulation pipes are typically used to repeatedly look up transportation costs based on a variety of factors (shipment weight, volume, total units) during the Simulation run. First the connection to the data source is defined, and then the simulation engine looks up the cost whenever needed. This type of pipe is used to populate the Variable Transportation Cost field in the Transportation Policies table. Scripted simulation pipes currently use .csv format files only as data sources.
Once you have selected the data source and table, use the process below to complete the definition of a scripted simulation input pipe.
Define a scripted simulation pipe
- Create a data source using a .csv file, as described in Creating a data source.
- Select “Scripted Simulation Pipe” as the Lookup Method. The Destination Table is automatically set to Transportation Policies. The Destination Field is automatically set to Variable Transportation Cost.
- Enter the value for the Column Lookup Field. The default is Shipment.TotalWeight. The following is a list of some common object properties that can be entered when using a dynamic simulation pipe:
- Lane.Name
- Lane.Zone
- Shipment.TotalWeight
- Shipment.TotalQuantity
- Shipment.TotalVolume
- Shipment.TotalValue
- Shipment.TotalDuty
- Shipment.TotalCost
- Enter the value for the Row Lookup Field using an object property such as those listed above. The default value is Lane.Zone.
For example, you may have a .csv file that provides transportation cost by weight. You can set the Row Lookup Value to “Shipment.TotalWeight” and the Column Lookup Value to “Shipment.TotalCost”.
Last modified: Wednesday May 15, 2024