Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • mlauber71
  • Spaces
  • Public
  • kn_example_r_excel_find_united_fields
  • m_001_import_r_excel_unite_fields
WorkflowWorkflow

m_001_import_r_excel_unite_fields

r excel knime import sheet +6

Last edited: 

Drag Workflow
Workflow preview
use R to list excel sheet names, extract the data and keep only columns that are present in all sheets use R package readxl to list all sheets of excel files from a folder, determine their sheets and columns and guess the type. In the end keep only those columns and data that are present in all files I built a solution but you may want to check it out if it works for you. With R I check all the sheets in the excel files from a folder. The sheets get imported and read back into KNIME the type is determined by a guess from the first 50k lines. Then I try to find out which combination of type and column name is there the most (all of the time - you might adapt that) and then only those are kept. But initially, all the data is loaded into KNIME so you might use it later. Filename and sheet-name are stored for later use.

External resources

  • original discussion
  • alternative solution with R's tibbles

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 4.0.2

  • KNIME Interactive R Statistics Integration Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.0.1

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