Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • mlauber71
  • Spaces
  • Public
  • forum
  • kn_example_r_readxl
  • m_001_r_readxl
WorkflowWorkflow

How to force column data type in “Excel Reader (XLS)” node?

excel xls xlsx guess import +2

Last edited: 

Drag Workflow
Workflow preview
I built a workflow that uses your idea and does three imports of an Excel file, one all numeric, one all strings and one guess. For the numeric ones when it might actually be a String there will be a huge number of missings. I do a calculation of % missing and I set a variable (75%) if there are 75% or more missing and the guess suggests a String it is a string. Obviously if you have date variables you would have to do something different. Here the results are stored in KNIME tables that are named after the Excel file and sheet and also contain columns with that information.

External resources

  • forum entry

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.0 Note: Not all extensions may be displayed.
  • KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • KNIME Interactive R Statistics Integration Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • KNIME Math Expression (JEP) Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

Legal

By downloading the workflow, you agree to our terms and conditions.

License (CC-BY-4.0)
Discussion
Discussions are currently not available, please try again later.

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
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits