Icon

02 Read Data from Workflow data area using Relative Paths

Read Data from Workflow Data Area using Relative paths

This workflow reads two files (Excel and KNIME table) from Workflow Data Area, joins them, and writes the result out as another Excel file.

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

Reading Data from Workflow Data Area

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 to KNIME Analytics Platform and move the data files (.xlsx and .table) to the Workflow data area.

Step 2: Double click on the “File reader”/”CSV Reader” node and select the "Relative to" and "Current workflow data area" options for “Read from”.

Step 3: In the File option click the browse option to locate the .xlsx or .table file on your local system with respect to the node.

Step 4: After locating the file, a preview will be generated, then click “OK”.

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

read KNIME Table from workflow directory
Table Reader
Join files using inner join
Joiner
read Excel File from workflow directory
Excel Reader
Output Table
Table View

Nodes

Extensions

Links