The Integrator List input object is a method of defining an input table within the script itself. This is useful for reducing the number of input files, especially for small lookup tables with static data, like converting month numbers to month names. The List object defines a set of columns, and defines an array of rows for these columns.
List Attributes
| Attribute | Type | Description |
|---|---|---|
| input_type (required) |
String | Identifies the object as a List input object. The value of this string is "list". |
| columns (required) |
Array of Strings | Defines the column names for the list. Column names should start with a letter. |
| values | Array of Strings | Defines the values for the input table. The attribute values is an array of array of strings. Each
string array defines a row. Either the values or column_values attribute is required. |
| column_values | Array of Strings | Defines the values for the input table when the input table consists of a single column. Each value in this array represents a different row in the input flow. This is useful in Tunnel situations where an array is passed in that should be used in an input flow. The values attribute does not lend itself to this type of use. The column_values attribute conflicts with the values attribute. One of values or column_values attributes is required. |
| trace_after | Sub-object |
Traces data flows leaving the specified object, which makes debugging scripts easier. This is equivalent to adding a Trace process object immediately after the current object. See Embedded Trace Object for more on using trace sub-objects. |