Icon

01 Read Data from the Local System

<p><strong>Read Data: From the Local System</strong></p><p>This workflow <strong>reads two file</strong>s (<em>.csv</em> and <em>.txt</em>) from your <strong>local system</strong>, joins them, and visualizes the result in a <em>Table View</em>.</p>

URL: KNIME Learning Center https://www.knime.com/learning
URL: KNIME Cheat Sheet: Building a KNIME workflow for beginners https://www.knime.com/cheat-sheets/building-knime-workflow-beginners
URL: YouTube: Data Access with KNIME: Reading Files https://youtu.be/BtOVuF4uy_Y?si=E4WhPq5pJacO2Cfk
URL: Data files for this workflow https://hub.knime.com/knactivation%20beta/spaces/Updated%20Beginners%20Space/Updated%20Beginners%20Space%20-%20Lisa/01%20Read/data~LDS0tnXYv0Bogmap/

Reading data from your local system

To read files from your local system follow these steps:

Step 1: Follow the link in the yellow annotation to the data folder and 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 "Source", specify the file path. Click the yellow folder button to browse your files. Select "Local file system" to access data from your local system.

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.

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 the 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
Visualize theoutput table
Table View
Join files on "RowID"using inner join
Joiner
Read file2.txtfrom local system
File Reader

Nodes

Extensions

Links