1 ×

Column Auto Type Cast

KNIME Base Nodes version 3.7.0.v201812031623 by KNIME AG, Zurich, Switzerland

This node determines the most specific type in the configured string columns and changes the column types accordingly. The type order is to first check if the values are dates, then integer, long, double, and finally string. For dates a custom format can be specified.

Options

Include
This list contains the column names which will get converted if possible.
Enforce Inclusion
Select this option to enforce the current inclusion list to stay the same even if the input table specification changes. If some of the included columns are not available anymore, a warning is displayed. (New columns will automatically be added to the exclusion list.)
Select
Use these buttons to move columns between the Include and Exclude list.
Exclude
This list contains the column names that are included in the output table without modification.
Enforce Exclusion
Select this option to enforce the current exclusion list to stay the same even if the input table specification changes. If some of the excluded columns are not available anymore, a warning is displayed. (New columns will automatically be added to the inclusion list.)
Choose a date format
Choose or enter a date pattern. (y: Year, M: Month in year, d: Day in month, H: Hour in day, m: Minute in hour, s: Second in minute, S: Millisecond)
Missing value pattern
Choose or enter a missing value pattern. <none> is the default pattern and <empty> represents the empty string. The entered string pattern is applied to all included columns.
Quickscan
Check this checkbox if you want to speed up the node. The node will determine the most specific type based on the first 1000 rows. 1000 is the default for the "number of rows to consider" field.
Note: With quickscan enabled this node could fail during execute.

Input Ports

Arbitrary input data.

Output Ports

Input data with type-casted columns.
Information about the chosen type casting.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Base Nodes from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.