Icon

02_​Read_​Data_​from_​Workflow_​data_​area_​using_​Relative_​Paths

Read Data from Workflow Data Area using Relative paths
Reading Data from Workflow Data AreaWhat 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/<username>/KNIME Workspace name/Workflow name (by default)To share the KNIME Workflows without breaking the links to the data files, it isrecommended to create a data folder in your Workflow directory and move your data filesthere. 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 “File reader”/”CSV Reader” node to KNIME Analytics Platform and movethe 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 yourlocal system with respect to the nodeStep 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 Excel File from workflow directoryread KNIME Tablefrom workflow directoryJoin filesusing inner joinOutput Table Excel Reader Table Reader Joiner Table View Reading Data from Workflow Data AreaWhat 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/<username>/KNIME Workspace name/Workflow name (by default)To share the KNIME Workflows without breaking the links to the data files, it isrecommended to create a data folder in your Workflow directory and move your data filesthere. 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 “File reader”/”CSV Reader” node to KNIME Analytics Platform and movethe 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 yourlocal system with respect to the nodeStep 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 Excel File from workflow directoryread KNIME Tablefrom workflow directoryJoin filesusing inner joinOutput Table Excel Reader Table Reader Joiner Table View

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: mpatt
Created at: 2022-03-21
On NodePit since: 2022-04-21
Last update: 2024-05-01
Created with KNIME version: v4.5.2
Tags: Table ReaderExcel ReaderJoinerColumn ResorterBeginnerBeginner Cheat SheetBeginners Space

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!