Icon

01 Data Access

Data Access - Exercise

This workflow shows a hands-on exercise in the L1-DS Introduction to KNIME Analytics Platform for Data Scientists - Basics course

Task 1: Read Data from a File1. Read the following files in the data folder using the appropriate reader nodes:- adult.csv- adult_education.table- adult_income.xlsxHint! You can drag and drop the files from KNIME Explorer to the workflow editor2. Change the file paths to workflow relative paths Task 2: Accessing Databases1. Read the web_activity table on the WebActivity.sqlite database available in the datafolder2. Read the data locally Reading adult.csvReading adult_education.tableReading adult_income.xlsxSelecting pathselecting tableReading the table CSV Reader Table Reader Excel Reader SQLite Connector DB Table Selector DB Reader Task 1: Read Data from a File1. Read the following files in the data folder using the appropriate reader nodes:- adult.csv- adult_education.table- adult_income.xlsxHint! You can drag and drop the files from KNIME Explorer to the workflow editor2. Change the file paths to workflow relative paths Task 2: Accessing Databases1. Read the web_activity table on the WebActivity.sqlite database available in the datafolder2. Read the data locally Reading adult.csvReading adult_education.tableReading adult_income.xlsxSelecting pathselecting tableReading the tableCSV Reader Table Reader Excel Reader SQLite Connector DB Table Selector DB Reader

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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2023-02-27
Last update: 2024-11-21
Created with KNIME version: v4.7.0
Tags: csvdata accesseducationexceltabledatabase

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

Try NodePit Runner!