Icon

01 Data Access - Solution

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