Select Values

Using Select Values Step you can rename the field names,change the metadata of the fields and you can drop the unwanted fields over there.


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.