Icon

02 Read Data from Workflow data area using Relative Paths

<p><strong>Read Data from Workflow Data Area using Relative Paths</strong></p><p>This workflow reads two files (<em>.xlsx</em> and <em>.table</em>) from Workflow Data Area, joins them, and visualizes the result in a <em>Table View</em>.</p>

URL: KNIME Self Paced Course https://www.knime.com/knime-self-paced-courses
URL: KNIME Cheat Sheet : Building a KNIME Workflow for Beginners https://www.knime.com/sites/default/files/2021-07/CheatSheet_Beginner_A3.pdf
URL: Reading files in KNIME - KNIME TV - YouTube https://www.youtube.com/watch?v=IiZsOnhZgzk

What is 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 the KNIME Workflows without breaking the links to the data files, it is recommended to create a data folder in your Workflow directory and move your data files there. This data folder in your Workflow directory is also called the "workflow data area". Follow the steps to access these files via relative links:

Step 1: Drag the “Excel Reader”/“Table Reader” node into your workflow and move the data files (.xlsx and .table) to the Workflow data area.

Step 2: Double click on the “Excel Reader”/”Table Reader” node. In the "Source" setting, browse the available files under "Embedded data" to locate the .xlsx or .table files available in the workflow data area.

Step 4: After locating the file, click “Apply”.

Step 5:Execute the node and the data will be loaded successfully.

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 Workflow Data Area using Relative Paths


This workflow reads two files (.xlsx and .table) from 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