Icon

01 Data Access - Solution

Data Access - Exercise (Solution)
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 adult_income.xlsxadult.csvadult_education.tableadult.csvWebActivity.sqliteweb_activity Excel Reader CSV Reader Table Reader File 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 adult_income.xlsxadult.csvadult_education.tableadult.csvWebActivity.sqliteweb_activityExcel Reader CSV Reader Table Reader File Reader SQLite Connector DB Table Selector DB Reader

Nodes

Extensions

Links