Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Column Auto Type Cast
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:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Math Formula Example
    data_coach > KNIME Foundations > 5 - Calculations and Aggregating Data > 1 - Math Formula > Math Formula Example
  2. Go to item
    Add page number to parsed pdf
    kathrin > Forum Questions > Add page number to parsed pdf
  3. Go to item
    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. Go to item
    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. Go to item
    2015_10_20_DataTransposing
    iris > Public > 02_ForumExamples > 2015_10_20_DataTransposing
  6. Go to item
    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. Go to item
    station
    duristef > Public > solutions > 20220301_station
  8. Go to item
    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. Go to item
    KNIME_project4
    sarada > Public > Workbook Learning > KNIME_House Price
  10. Go to item
    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
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits