Icon

02 Read Data from a Workflow Data Area using Relative Paths

<p><strong>Read Data: From a Workflow Data Area using Relative Paths</strong></p><p>This workflow <strong>reads two files</strong> (<em>.xlsx</em> and KNIME's native <em>.table</em> format) from the <strong>workflow data area</strong>, joins them, and visualizes the result in a <em>Table View</em>.</p>

URL: KNIME Learning Center https://www.knime.com/learning
URL: KNIME Cheat Sheet: Building a KNIME workflow for beginners https://www.knime.com/cheat-sheets/building-knime-workflow-beginners
URL: YouTube: Data Access with KNIME: Reading Files https://youtu.be/BtOVuF4uy_Y?si=E4WhPq5pJacO2Cfk

What is the workflow data area?

The workflow and its contents are stored in your system in the workflow directory:

  • Windows OS: C:/users/KNIME Workspace name/Workflow name (by default)

  • MacOS: /Users//KNIME Workspace name/Workflow name (by default)

To share a KNIME workflow without breaking the links to the data files, it is recommended to create a data folder inside your workflow directory and move your data files there. This data folder in your workflow directory is also called the "workflow data area".

For this example, we have saved two data files (.xlsx and .table) inside the workflow data area. Follow these steps to access these files via workflow-relative links:

Step 1: Drag the "Excel Reader"/"Table Reader" node into your workflow.

Step 2: Click on the "Excel Reader"/"Table Reader" node. Under "Source", specify the file path. Click the yellow folder button to browse your files. Select "Embedded data" to locate the .xlsx or .table files available in the workflow data area.

Step 3: After locating the file, you can define the file format. For example, you can specify to skip lines or whether the file has a column header. Click "Apply" to save the settings.
Tip: The "Autodetect format" button automatically guesses the file format.

Step 4: Execute the node to load the data into KNIME.

Workflow complete!

Keep the momentum going by exploring Just KNIME It! on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.

Read Data: From a Workflow Data Area using Relative Paths


This workflow reads two files (.xlsx and KNIME's native .table format) from the workflow data area, joins them, and visualizes the result in a Table View.

Read file2.tablefrom workflow data area
Table Reader
Join files on "RowID"using inner join
Joiner
Read file1.xlsxfrom workflow data area
Excel Reader
Visualizeoutput table
Table View

Nodes

Extensions

Links