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 can use data from the following sources.
- Container components
- Other Select components
- Lookup tables
You can give meaningful names to the fields in the records that Select passes to downstream components.
You can also apply functions to the fields, and group and sort the fields to further filter the results.
When you use more than one WHERE clause to refine the record set, you can specify whether to evaluate them using either AND or OR.
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 Sort | You can apply an ascending or descending sort to the records. Optional. When multiple fields have sort applied, the sort is applied based on the order in which the rows are shown. |
| Primary Date | If selected, the field is designated as a timestamp field. |