Icon

How to Build a Component Composite View

<p><strong>How to build a Component Composite View</strong></p><p>We have access to historical Olympics data, saved in different tables, and we want to load, prepare, and visualize the data.</p><ul><li><p>First table: A list of all the Summer and Winter Olympic Games from 2000 to 2022.</p></li><li><p>Second table: The medal tally for all countries at all Olympic Games (bronze, silver, gold, and total). Countries which never won a medal are not included in this dataset.</p></li></ul><p>After we have analyzed the data, we want to share the insights as a composite view, combining multiple visualizations in one view. The composite view includes:</p><ol><li><p>A bar chart showing the top 5 countries with most medals won.</p></li><li><p>A table view listing the medal tally for all countries.</p></li><li><p>A text view containing a title and additional information about the respective Olympics Games edition.</p></li></ol><p><strong>In this workflow, you will learn how to:</strong></p><ul><li><p>Prepare data for reporting</p></li><li><p>Visualize data using KNIME View nodes</p></li><li><p>Create a component composite view that contains multiple view nodes</p></li></ul><p>💡 At a glance:</p><p>In KNIME, a node can be in four different states:</p><ol><li><p><strong>Not configured</strong>🔴. The node is waiting for configuration or incoming data.</p></li><li><p><strong>Configured</strong>🟡. The node has been configured and can be executed.</p></li><li><p><strong>Executed</strong>🟢. The nodes has been successfully executed. Results can be viewed in the node monitor and be used in downstream nodes.</p></li><li><p><strong>Error</strong>❌. The node has encountered an error during execution.</p></li></ol><p>⚙️ To configure a node, click the node to open the configuration panel (right side of the workflow canvas). Change the settings and don't forget to click <strong>"Apply"</strong>.</p><p>▶️ After configuration, you can execute the node. Hover over the node and click the "Execute" button in the node action bar.</p><p>🤖 If you are stuck, let K-AI, our AI assistant, help you build workflows. Access K-AI in the "K-AI" panel on the left side of the workflow canvas.</p><p>For detailed instructions and a getting started guide, we recommend the KNIME Documentation.</p>

How to Build a Component Composite View


We have access to historical Olympics data, saved in different tables, and we want to load, prepare, and visualize the data.

  • First table: A list of all the Summer and Winter Olympic Games from 2000 to 2022.

  • Second table: The medal tally for all countries at all Olympic Games (bronze, silver, gold, and total). Countries which never won a medal are not included in this dataset.

After we have analyzed the data, we want to share the insights as a composite view, combining multiple visualizations in one view. The composite view includes:

  1. A bar chart showing the top 5 countries with most medals won.

  2. A table view listing the medal tally for all countries.

  3. A text view containing a title for the composite view and additional information about the respective Olympics Games edition.


In this workflow, you will learn how to:

  • Prepare data for reporting

  • Visualize data using KNIME View nodes

  • Create a component composite view that contains multiple view nodes

Access data

We load historical Olympics data:

  1. A list of all Summer and Winter Olympic Games from 2000 to 2022.

  2. The medal tally for all countries and all Olympic Games editions.

We prepare the data for reporting. This includes:

  • Replacing the alpha-3 country codes with the full country names.

  • Sorting the data by year in ascending order.

Preprocess data for reporting
💡 At a glance:

In KNIME, a node can be in four different states:

  1. Not configured🔴. The node is waiting for configuration or incoming data.

  2. Configured🟡. The node has been configured and can be executed.

  3. Executed🟢. The nodes has been successfully executed. Results can be viewed in the node monitor and be used in downstream nodes.

  4. Error❌. The node has encountered an error during execution.

⚙️ To configure a node, click the node to open the configuration panel (right side of the workflow canvas). Change the settings and don't forget to click "Apply".

▶️ After configuration, you can execute the node. Hover over the node and click the "Execute" button in the node action bar.

🤖 If you are stuck, let K-AI, our AI assistant, help you build workflows. Access K-AI in the "K-AI" panel on the left side of the workflow canvas.


For detailed instructions and a getting started guide, we recommend the KNIME Documentation.

Build a component composite view to represent data insights in an interactive report.

💡To open a component, right click the component and select "Component" > "Open component"; or hold CTRL and double-click the component.

💡 Change the value of the flow variable "edition" (e.g., to "2020 Summer Olympics") and see how the component composite view changes.

Build component composite view
Create flow variable

We create a flow variable "edition" that specifies the edition of the Olympics Games we are interested in.

In this example, the flow variable has the value "2014 Winter Olympics".

💡 To encapsulate a sub-workflow into a component, select the relevant nodes, right-click the selection and click "Create component".

Country codesto full country name
String Replacer (Dictionary)
Create variable to select edition(2014 Winter Olympics)
Variable Creator
Load medal tally
Table Creator
Olympics Results
Load information aboutOlympics Games 2000-2022
Table Creator
Sort by year
Sorter

Nodes

Extensions

Links