Icon

04. Data app - File Up- and Download - solution

Create an interactive dashboard in 3 steps: Netflix dataset

This workflow creates an interactive visualization dashboard of the "Netflix Movies and TV Shows" dataset. The charts are grouped in components and can be displayed either locally or from the KNIME WebPortal

2. Open component to add a header Create an interactive Watchlist builder with Single viewThe goal of this exercise is to build a web application for exploring movies and shows based on their properties, where 1. the user can upload a file with their own data 2. download a file with the results and selection from this web applicationDeploy on Server: Make sure to reset the workflow! 6. Use the Variable Creatornode to create the name ofthe output file.variable name: file-namevariable type: Stringvalue: watchlist 7. Use the Excel Writerto write your file to thecreated temporarylocationuse the flow variable"output" for the path. 4. Use the Row Filter node tofilter the rows, which wereselected by the user from thetile view. Select the column" Selected (Tile View)" anduse pattern matching on"true". Include only matchingrows. 5. Use the Breakpoint node tofail if the Table from the Rowfilter node is empty (=user didnot select any rows).In its configuration, enable thebreakpoint and add a custommessage. 1. Drag in the Generic File Uploadcomponent and connect it to thePreprocessing metanode. Configure it toread the netflix_titles_1.csv or thenetflix_titles_2.table file.Link to verified component on KNIME Hub:https://kni.me/c/3NB_HftP7bedG-c8or in components folder Convert toDate&Time formatSunburstStacked Area chartBar chartHistogramTile Viewhalt if no data is selected Preprocessing Moview Row Filter Try (Data Ports) Catch Errors(Data Ports) Breakpoint Download File Excel Writer Column Filter Create Temp Folder Variable Creator Generic File Upload 2. Open component to add a header Create an interactive Watchlist builder with Single viewThe goal of this exercise is to build a web application for exploring movies and shows based on their properties, where 1. the user can upload a file with their own data 2. download a file with the results and selection from this web applicationDeploy on Server: Make sure to reset the workflow! 6. Use the Variable Creatornode to create the name ofthe output file.variable name: file-namevariable type: Stringvalue: watchlist 7. Use the Excel Writerto write your file to thecreated temporarylocationuse the flow variable"output" for the path. 4. Use the Row Filter node tofilter the rows, which wereselected by the user from thetile view. Select the column" Selected (Tile View)" anduse pattern matching on"true". Include only matchingrows. 5. Use the Breakpoint node tofail if the Table from the Rowfilter node is empty (=user didnot select any rows).In its configuration, enable thebreakpoint and add a custommessage. 1. Drag in the Generic File Uploadcomponent and connect it to thePreprocessing metanode. Configure it toread the netflix_titles_1.csv or thenetflix_titles_2.table file.Link to verified component on KNIME Hub:https://kni.me/c/3NB_HftP7bedG-c8or in components folder Convert toDate&Time formatSunburstStacked Area chartBar chartHistogramTile Viewhalt if no data is selected Preprocessing Moview Row Filter Try (Data Ports) Catch Errors(Data Ports) Breakpoint Download File Excel Writer Column Filter Create Temp Folder Variable Creator Generic File Upload

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: Emilio Silvestri
Created at: 2020-04-14
On NodePit since: 2023-06-12
Last update: 2024-04-27
Created with KNIME version: v4.6.5
Tags: sunburst chartline plotbar charthistogramvisualizationinteractive dashboardstacked area chartinteractive filter

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

Try NodePit Runner!