Icon

01 Data Access

01 Data Access - Exercise (Solution)

This workflow shows a solution to 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 OR Task 2: Read data from database1. Read the LifeExpectancy table in the Demographics.sqlite database that you can find inthe data folder Demographics.sqliteLifeExpectancydemographics.xlsx(population)demographics.xlsx(life_expectancy)travel_advidories.csvgeo_coordinates.tabletravel_advidories.csvread locally SQLite Connector DB Table Selector Excel Reader Excel Reader CSV Reader Table Reader File Reader 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 OR Task 2: Read data from database1. Read the LifeExpectancy table in the Demographics.sqlite database that you can find inthe data folder Demographics.sqliteLifeExpectancydemographics.xlsx(population)demographics.xlsx(life_expectancy)travel_advidories.csvgeo_coordinates.tabletravel_advidories.csvread locallySQLite Connector DB Table Selector Excel Reader Excel Reader CSV Reader Table Reader File Reader 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-22
Last update: 2024-05-01
Created with KNIME version: v4.6.3
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!