Icon

ciullajn_​DataExportandReporting_​CustomData

John CiullaIT 4015CLab 2 - Data Wrangling in KNIME AdvancedMay 23, 2023Exercise 01 - Data Export and Reporting Task 1: Write Data to a FileRead the meteorite_landings.csv file.1. Filter the data to the show found meteorites in the fall column2. Filter to show only above 1 million in mass3. Write the filtered data into a “largemeteoritesfound” file in the data folder. Overwrite the file if italready exists. Task 2: Create a BIRT Report1. Execute the workflow2. Send the output of the top branch, the pivot table, to BIRT for use in areport3. 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 meteorite_landings.csvFoundMass >= 1 millNumber of meteoritesbased on nametypeto 0Show the statsFiltered data to reportmeteoritesWritelargemeteoritesfound.csvNumber of meteoritesbased on nametype CSV Reader Row Filter Row Filter Pivoting Missing Value Bar Chart Data to Report Image to Report CSV Writer Pivoting John CiullaIT 4015CLab 2 - Data Wrangling in KNIME AdvancedMay 23, 2023Exercise 01 - Data Export and Reporting Task 1: Write Data to a FileRead the meteorite_landings.csv file.1. Filter the data to the show found meteorites in the fall column2. Filter to show only above 1 million in mass3. Write the filtered data into a “largemeteoritesfound” file in the data folder. Overwrite the file if italready exists. Task 2: Create a BIRT Report1. Execute the workflow2. Send the output of the top branch, the pivot table, to BIRT for use in areport3. 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 meteorite_landings.csvFoundMass >= 1 millNumber of meteoritesbased on nametypeto 0Show the statsFiltered data to reportmeteoritesWritelargemeteoritesfound.csvNumber of meteoritesbased on nametype CSV Reader Row Filter Row Filter Pivoting Missing Value Bar Chart Data to Report Image to Report CSV Writer Pivoting

Nodes

Extensions

Links