Icon

01 Read Data from Local System

<p><strong>Read Data from your Local System</strong></p><p>This workflow reads two files (<em>.csv</em> and <em>.txt</em>) from your local system, 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
URL: Data Files for this Workflow http://hub.knime.com/knime/spaces/s/latest/~PjQaQzthGlXGjQWi/

Reading Data from your local system

To read files from your local system follow the steps:

Step 1: Use the download link given in the yellow annotation, download the files - "file1.csv" and "file2.txt" to your local system. Drag the "CSV Reader" and "File Reader" nodes into the workflow.

Step 2: Click on the "CSV Reader"/"File Reader" node to open the configuration window. Under "Read from", select the "Local File System" option.

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 "OK".

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

Note: The data files for this workflow are available in the data folder in "01 Read". Download file1.csv and file2.txt.

Read Data from your Local System


This workflow reads two files (.csv and .txt) from your local system, joins them, and visualizes the result in a Table View.

Read file1.csvfrom local system
CSV Reader
Visualizeoutput table
Table View
Join files on "RowID"using inner join
Joiner
Read file1.txtfrom local system
File Reader

Nodes

Extensions

Links