Icon

01 Read Data Loading Example

Read Data from Local System

This workflow can be used to read two files (Text and CSV) from the user's local system and then join them, and writes the result out as another CSV 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
URL: Data Files for this Workflow http://hub.knime.com/knime/spaces/s/latest/~PjQaQzthGlXGjQWi/

Reading Data from the local system

To read files from your local system follow the steps:

Step 1: Using the download link given in yellow annotation, download the files - "file1.txt" and "file2.csv" to your local system. Drag the "File Reader" and "CSV Reader" node to the KNIME Analytics Platform.

Step 2: Double click on the "File Reader"/"CSV Reader" node and select the "Local File System" option for Read from.

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

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

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

Note : The data files for this workflow are available at thislink.

Download the file1.txt and file2.csv.

read CSV file from workflow directory
CSV Reader
Output Table
Table View
Join files using inner join
Joiner
read Text file workflow data area
File Reader

Nodes

Extensions

Links