What is the workflow data area?
The workflow and its contents are stored in your system in the workflow directory:
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.