Column Auto Type Cast
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.
- Type: Data Arbitrary input data.
- Type: Data Input data with type-casted columns.
- Type: Data Information about the chosen type casting.
Manipulation > Column > Convert & Replace
Make sure to have this extension installed: