Page Operations
Browse SpaceDescription
This Select values step is useful for selecting, renaming, changing data types and configuring the length and precision of the fields on the stream. These operations are organized into different categories:
- Select & Alter - Specify the exact order and name in which the fields have to be placed in the output rows
- Remove - Specify the fields that have to be removed from the output rows
- Meta-data - Change the name, type, length and precision (the meta-data) of one or more fields
Select & Alter
The table below contains options under the "Select & Alter" tab:
| Option | Description |
|---|---|
| Step name | Name of the step; this name has to be unique in a single transformation |
| Fields | Allows you to rename a field and specify the length and precision |
| Get fields to | Click to insert fields from all input steams |
| select | to the step |
| Edit Mapping | Click to open a mapping dialog to easily define multiple mappings between source and target fields. Note: Works if there is only one target output step. |
| Include unspecified fields, ordered by name | Enable if you want to implicitly select all other fields from the input stream(s) that are not explicitly selected in the Fields section |
Remove
This tab allows you to enter the fields that you want removed from the stream. You can also click Get fields to remove to add all fields from the input stream(s). This makes it easier if you are trying to remove several fields. After getting all fields, delete any of the fields that you do not want remove from the stream.
Metadata
This tab allows you to rename, change data types, and change the length and precision of fields coming into the Select Values step. Click Get fields to import fields from previous steps.
A lot of data type conversions are also possible with this tab.
Examples
samples/transformations/Select values - some variants.ktr
samples/transformations/Select Values - copy field values to new fields.ktr