Icon

02 Write Data to a file

01 Data Export and Reporting - Exercise

This workflow shows a hands-on exercise in the L2-DW Introduction to KNIME Analytics Platform for Data Wranglers - Advanced course


Task 2: Create a BIRT Report1. Execute the provided workflow. It aggregates and visualizes population and travel risk information on the different continents. 2. Send the output of the top branch, the pivot table, to BIRT for use in a report3. Send the bar chart to BIRT4. In the BIRT Report editor, use a grid to layout the following elements:- A report title- A pivot table- A bar chart Task 1: Write Data to a FileRead the JoinedCountryTable.table file by executing the Table Reader node. This table contains information about the demographics,geolocation, and travel risks in the different countries/territories in 2020.1. Filter the data to the countries/territories in the travel risk category 1 (Exercise normal precautions)2. Filter these data to countries/territories with a maximum one million inhabitants in 20193. Write the filtered data into a “SmallSafeCountries.csv” file in the data folder. Overwrite the file if it already exists. I'm struggling to understand how to use pivot. I am reallynot sure what I did here, I was lucky it would evenexecute because I kept trying different things and it wouldget stuck executing. Since the column fall only has 2options, found and fell, I wanted to see the geolocation ofthe found ones associated with its ID. That is what I wastrying to do but I don't think I was successful ? Same ?recclass L4"fell" = YesWritemeteorite.csvtableMeteorite dataPivoting Bar Chart Pivoting Row Filter Row Filter CSV Writer Data to Report Image to Report CSV Reader Task 2: Create a BIRT Report1. Execute the provided workflow. It aggregates and visualizes population and travel risk information on the different continents. 2. Send the output of the top branch, the pivot table, to BIRT for use in a report3. Send the bar chart to BIRT4. In the BIRT Report editor, use a grid to layout the following elements:- A report title- A pivot table- A bar chart Task 1: Write Data to a FileRead the JoinedCountryTable.table file by executing the Table Reader node. This table contains information about the demographics,geolocation, and travel risks in the different countries/territories in 2020.1. Filter the data to the countries/territories in the travel risk category 1 (Exercise normal precautions)2. Filter these data to countries/territories with a maximum one million inhabitants in 20193. Write the filtered data into a “SmallSafeCountries.csv” file in the data folder. Overwrite the file if it already exists. I'm struggling to understand how to use pivot. I am reallynot sure what I did here, I was lucky it would evenexecute because I kept trying different things and it wouldget stuck executing. Since the column fall only has 2options, found and fell, I wanted to see the geolocation ofthe found ones associated with its ID. That is what I wastrying to do but I don't think I was successful ? Same ?recclass L4"fell" = YesWritemeteorite.csvtableMeteorite dataPivoting Bar Chart Pivoting Row Filter Row Filter CSV Writer Data to Report Image to Report CSV 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-10-23
On NodePit since: 2023-03-09
Last update: 2024-05-05
Created with KNIME version: v4.7.0
Tags: educationl2-dwself-paced

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

Try NodePit Runner!