Select components

Select components perform operations that are similar to the SQL SELECT database query with optional WHERE clauses. A Select component holds a set of records that you define, and on which you can perform further operations.

Select components pull their data from Container components.

You can give meaningful names to the fields in the records that Select passes to downstream components.

You can also apply functions to the record set, and group and sort the records to further filter the results.

When you use more than one WHERE clause to refine the record set, the clauses are evaluated using AND.

Fields in the Output panel of the Select component editor

Table 1. Fields in the Output panel of the Select component editor
Field	Description
Name	Name of the field in the originating data source. Read only.
Data Type	Data type of the originating field. Read only.
Output Name	Name of the field in the record that Select passes on to downstream components. You can supply a different name, or retain the original name. When the Trigger Table data source connector is used to process the trigger system that contains the Select, these labels become the names of fields in the trigger table. Optional.
Output Function	Function to apply to the data in this field. Optional. Tip: For help with functions, see the related topics.
Output Data Type	Depending on whether a function is applied to the data in this field, the data type may change. Read only, calculated automatically for information purposes.
Output Sort	You can apply an ascending or descending sort to the records. Optional.
Primary Time Stamp	If selected, the field is designated as a timestamp field.