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

  1. Math Formula Example
    data_coach > KNIME Foundations > 5 - Calculations and Aggregating Data > 1 - Math Formula > Math Formula Example
  2. Add page number to parsed pdf
    kathrin > Forum Questions > Add page number to parsed pdf
  3. Field Types and Conversions Solution
    data_coach > KNIME Foundations > 4 - Field Types and Conversions > 4 - Field Types and Conversions Practice > Field Types and Conversions Solution
  4. ITunes Library Cleanup
    Example workflow showing how to parse an ITunes XML library file and do string matching t…
    pwisneskey > Public > ITunes Library Cleanup
  5. 2015_10_20_DataTransposing
    iris > Public > 02_ForumExamples > 2015_10_20_DataTransposing
  6. Nodes for Converting Field Types Example
    data_coach > KNIME Foundations > 4 - Field Types and Conversions > 3 - Nodes for Converting Field Types > Nodes for Converting Field Types Example
  7. station
    duristef > Public > solutions > 20220301_station
  8. Missing Value Handling - Solution
    Data manipulation Preprocessing Missing value
    +4
    Introduction to Machine Learning Algorithms course - Session 4 Solution to exercise 2 Han…
    hayasaka > L4-ML-2Hrs-2021-07 > Solutions > 05_Missing_Value_Handling_solution
  9. KNIME_project4
    sarada > Public > Workbook Learning > KNIME_House Price
  10. Missing Value Handling - Solution
    Data manipulation Preprocessing Missing value
    +4
    Introduction to Machine Learning Algorithms course - Session 4 Solution to exercise 2 Han…
    knime > Education > Courses > L4-ML Introduction to Machine Learning Algorithms > Session_4 > 02_Solutions > 02_Missing_Value_Handling_solution