Icon

First steps with KNIME AI Assistant (K-AI) 5.8

<p>This workflow shows how to create a component with visualizations from scratch (even if you are new to KNIME) using the KNIME AI Assistant (K-AI) and some human interaction</p>

✨ First steps with KNIME AI Assistant (K-AI) - v5.8

This workflow shows how to create a component with visualizations from scratch (even if you are new to KNIME) using the KNIME AI Assistant (K-AI) and some human interaction

1. Add your first nodes

  1. Let's add one node: (Just search for Data) => Example data Reader => Drag and Drop.

  2. Configure the node to read the "Worldbank population data" => Execute

  3. Show the table view, explain the data. (The data is on purpose a bit messy)

  4. We now want to filter columns which are fully missing.

  5. Use the quick node insertion (Click on output port, pull connection and release)

  6. Insert the first node: Column Filter manually Filter Column 2 and 5.

  7. What if we don't know which node to use? Go to the KAI tab.

2. First steps in K-AI

  1. First of all, you need to have a hub.knime.com account to use this service.

  2. Go to the K-AI section in the left sidebar of KNIME Analytics Platform and log with your hub.knime.com account

  3. Now you should be able to see the Q&A mode and the Build mode.

3. Using K-AI

  1. In Q&A Mode ask: ‘I need to remove missing values, how could I do that?’ - Use the suggested node

  2. In Build Mode ask:‘rename Column4 to Population size and Column3 to Country’.

  3. Take advantage of this and rename the different columns.

  4. In Build Mode ask: ‘Population size is String, I need to convert this column to Integer'. Hints:

    1. Filter only the Population size Column

    2. Use "." as Decimal separator

    3. Use "," as Thousand separator

    4. Use type "Number (integer)"

  5. In Build Mode ask: ‘filter the 20 countries with the highest population size’.

  6. Be creative by adding nodes like Pie Chart / Bar Chart / Table View / Text View

  7. Now use ’Generic ECharts View’ node and click in ’Ask AI’ and ask the following: ’create the best visualisation to show the top 10 countries by population size and highlight in red the top 3 countries’

  8. Create a Component with all the visualisations and put it nicely

  9. Extra: Activate Report mode and save it to your computer and Send it by email

  10. You should end up with a Component like the one provided below called “Created by K-AI”.

Example Data Reader
Created by K-AI

Nodes

Extensions

Links