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