Icon

01 Data Access

01 Data Access - Exercise

This workflow shows a hands-on exercise in the L1-DW KNIME Analytics Platform for Data Wranglers: Basics course


Task 1: Read data from file1. Read the following files, available in the data folder, using the appropriate reader nodes:- population sheet in the demographics.xlsx file- life_expectancy sheet in the demographics.xlsx file- travel_advisories.csv- geo_coordinates.tableHint! You can drag and drop the files from KNIME Explorer to the workflow editor2. Change the file paths to workflow relative paths Task 2: Read data from database1. Read the LifeExpectancy table in the Demographics.sqlite database that you can find inthe data folder demographics.xlsx Populationgeo_coordinates.tabletravel_advisories.csvdemographics.xlsx Life ExpectancyNode 5Node 7Node 8 Excel Reader Table Reader CSV Reader Excel Reader DB Reader DB Table Selector SQLite Connector Task 1: Read data from file1. Read the following files, available in the data folder, using the appropriate reader nodes:- population sheet in the demographics.xlsx file- life_expectancy sheet in the demographics.xlsx file- travel_advisories.csv- geo_coordinates.tableHint! You can drag and drop the files from KNIME Explorer to the workflow editor2. Change the file paths to workflow relative paths Task 2: Read data from database1. Read the LifeExpectancy table in the Demographics.sqlite database that you can find inthe data folder demographics.xlsx Populationgeo_coordinates.tabletravel_advisories.csvdemographics.xlsx Life ExpectancyNode 5Node 7Node 8Excel Reader Table Reader CSV Reader Excel Reader DB Reader DB Table Selector SQLite Connector

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-05-21
Last update: 2024-05-01
Created with KNIME version: v4.7.2
Tags: educationl1-dw

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

Try NodePit Runner!