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 in the data folder Life Expectancy SheetPopulation SheetTravel AdvisoriesNode 4Node 5Demographics.sqliteLifeExpectancyread locally Excel Reader Excel Reader CSV Reader CSV Reader Table Reader SQLite Connector DB Table Selector DB Reader 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 in the data folder Life Expectancy SheetPopulation SheetTravel AdvisoriesNode 4Node 5Demographics.sqliteLifeExpectancyread locally Excel Reader Excel Reader CSV Reader CSV Reader Table 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-01-21
Last update: 2024-04-24
Created with KNIME version: v4.7.0
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!