Hub
NodeNode / Manipulator

Column Auto Type Cast

Manipulation Column Convert & Replace
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Input
    Arbitrary input data.
Output ports
  1. Type: Table
    Type-casted columns
    Input data with type-casted columns.
  2. Type: Table
    Type information
    Information about the chosen type casting.

Extension

The Column Auto Type Cast node is part of this extension:

Related workflows & nodes