1. Select Build > Input Pipes .
2. On the Input Pipes tab, click New Input Pipe.
3. Edit the Name (the default name is “New Input Pipe (n)”).
4. Select the Data Source. This is a data source you have defined as described in Creating a data source or the names of any User Defined Tables you have created. If you need to create a data source, click New to access the External Data Source form, then follow the instructions in Creating a data source.
5. Select the Lookup Method. This is one of:
   • Standard Lookup
   • Matrix Lookup
   • Scripted Simulation Pipe
6. For Standard Lookup and Matrix Lookup input pipes, select the Destination Table into which the input pipe data will be populated.
7. For Standard Lookup and Matrix Lookup input pipes, select the Destination Field into which the input pipe data will be populated.
8. Optionally enter a Default Destination Value. This value will be used when the lookup into the input pipe fails. For example, if you are creating an input pipe for Variable Transportation Cost in Transportation Policies, you may want to set a large Default Destination Value to prevent the design engines from using the policy if the lookup fails.

The rest of the input pipe definition depends on the Lookup Method.