Icon

01 Read Data from File - Solution

Solution to an exercise for reading data from a file

CHECK YOUR ANSWERS:
a. The reader nodes to use are Excel Reader, CSV Reader/File Reader, and Table Reader
b. The geo coordinates table has the most rows (245)















Exercise: Read Data from FileRead 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 editorChange the file paths to workflow relative paths ORdemographics.xlsx(population)demographics.xlsx(life_expectancy)travel_advidories.csvgeo_coordinates.tabletravel_advidories.csvExcel Reader Excel Reader CSV Reader Table Reader File Reader Exercise: Read Data from FileRead 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 editorChange the file paths to workflow relative paths ORdemographics.xlsx(population)demographics.xlsx(life_expectancy)travel_advidories.csvgeo_coordinates.tabletravel_advidories.csvExcel Reader Excel Reader CSV Reader Table Reader File 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-04-14
Last update: 2024-11-19
Created with KNIME version: v4.7.0
Tags: csvdata accessexceltable

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

Try NodePit Runner!