Convert Type (In Database)
(In-Database Processing)
Synopsis
Changes the data type of the selected columns.Description
Converts the data type of the chosen column. You can specify a default conversion that is applied on all columns that the attribute filter selects. You can also specify individual column data type conversions. The suggested data types are database-specific, and you can manually enter types that are not in the drop-down list. Note that for certain types, you may further specify the type, e.g. DECIMAL(8,2), NUMERIC(6,3), VARCHAR2(150). Data types in the output metadata are only available for these database-specific values, otherwise, the generic attribute_value is used.
Input
example set input
Output
example set output
Parameters
- use_default_type_conversion If checked you can select a default type conversion for a subset of the attributes. Range: boolean
- attribute_filter_type The condition specifies which attributes are selected or affected by this operator. Range: selection
- attribute The attribute which should be chosen. Range: string
- attributes The attribute which should be chosen. Range: string
- regular_expression A regular expression for the names of the attributes which should be kept. Range: string
- use_except_expression If enabled, an exception to the specified regular expression might be specified. Attributes of matching this will be filtered out, although matching the first expression. Range: boolean
- except_regular_expression A regular expression for the names of the attributes which should be filtered out although matching the above regular expression. Range: string
- value_type The value type of the attributes. Range: selection
- use_value_type_exception If enabled, an exception to the specified value type might be specified. Attributes of this type will be filtered out, although matching the first specified type. Range: boolean
- except_value_type Except this value type. Range: selection
- block_type The block type of the attributes. Range: selection
- use_block_type_exception If enabled, an exception to the specified block type might be specified. Range: boolean
- except_block_type Except this block type. Range: selection
- numeric_condition Parameter string for the condition, e.g. '>= 5' Range: string
- invert_selection Indicates if only attributes should be accepted which would normally filtered. Range: boolean
- default_type_conversion Default Type Conversion Range: string
- type_conversions List of type conversions. Range: list