KNIME Analytics Platform Version 5 Starter Perspective Collection – knime – KNIME Community Hub

Search

Software
Blog
Forum
Events
Documentation
About KNIME

KNIME Community Hub
knime
Collections
KNIME Analytics Platform Version 5 Starter Perspective Collection

Collection

KNIME Analytics Platform Version 5 Starter Perspective Collection

Spreadsheets Excel CSV Beginners

Browse working examples, node explanations and further resources for testing KNIME Analytics Platform Version 5.

New to KNIME?

Get started with the Release of Version 5 of the KNIME Analytics Platform to use all the examples and nodes you need for an easy start!

Last edit:

Like

Workflow examples

Below, find examples for the most common data manipulation tasks. Recommended for beginners, particularly spreadsheet users, who are new to visual workflows

Reading spreadsheets

Start your data analysis journey with KNIME: A beginner's workflow list for reading in data.

Workflow

Merge Files

Spreadsheets Excel Merge

This workflow merges different unstructured data sources to come up with a new table.Since data come from different data files, w…

knime > KNIME for Spreadsheet Users > Merge Files

0

Workflow

Non-standard format Spreadsheets

Excel Spreadsheet

This workflow shows how to work with spreadsheets that come in a non-standard format using KNIME Analytics Platform. The aim is t…

knime > KNIME for Spreadsheet Users > Non-standard format Spreadsheets

0

Workflow

Read Data from Different Sources

This workflow shows how to read, merge and manipulate data from different sources (Gsheet, excel file) using KNIME Analytics Plat…

knime > KNIME for Spreadsheet Users > Read Data from Different Sources

0

Workflow

Joining Spreadsheets

Spreadsheet Join Excel

In this workflow, we see how to use the Joiner node to clean up a dataset using KNIME Analytics Platform. Sometimes more than a V…

knime > KNIME for Spreadsheet Users > Joining Spreadsheets

0

Workflow

Calculate Totals (Multiple Files)

Excel Spreadsheet Concatenate

This workflow shows how to calculate the totals of multiple files using KNIME Analytics Platform. The aim is to concatenate the i…

knime > KNIME for Spreadsheet Users > Calculate Totals (Multiple Files)

0

Manipulating data in spreadsheets

Learn how to automate the combining of data from disparate spreadsheets.

Workflow

VLOOKUP Function (Same Sheet)

VLOOKUP Spreadsheet Excel

This workflow shows how to perform a VLOOKUP function between two tables in the same sheet, using KNIME Analytics Platform. The w…

knime > KNIME for Spreadsheet Users > VLOOKUP function (Same Sheet)

0

Workflow

CountIf and SumIf

This workflow shows how to perform a SumIf and a CountIf function in KNIME Analytics Platform. Of course, there are different way…

knime > KNIME for Spreadsheet Users > CountIf and SumIf

0

Workflow

Pivot Table

Spreadsheet Excel

A pivot table aims to arrange a table so that other stakeholders can easily share and understand data. Let's walk through the dif…

knime > KNIME for Spreadsheet Users > Pivot Table

1

Workflow

Join Strings (Multiple Sheets)

Excel Spreadsheet Concatenate

+1

This workflow shows how to concatenate tables from two different sheets and combine string-type columns using KNIME Analytics Pla…

knime > KNIME for Spreadsheet Users > Join Strings (Multiple Sheets)

0

Workflow

VLOOKUP Function (Different Files)

Excel Spreadsheet Value Lookup

+2

This workflow shows how to perform a VLOOKUP function on a table using a table from a different file as dictionary, in KNIME Anal…

knime > KNIME for Spreadsheet Users > VLOOKUP function (Different Files)

0

Advanced spreadsheet manipulation

Once you have the hang, the fundamentals, check out some real-world advanced examples below.

Workflow

Charts and Spreadsheets

Value Lookup Pie Chart Bar Chart

+3

This workflow shows how to create charts from spreadsheet data and add them to a new spreadsheet using KNIME Analytics Platform. …

knime > KNIME for Spreadsheet Users > Charts and Spreadsheets

0

Workflow

Create and Send Report

Excel Email Report

Create And Send Report In this workflow, we see how to build and send a report via email using KNIME Analytics Platform. The idea…

knime > KNIME for Spreadsheet Users > Create and Send Report

1

Workflow

Spreadsheets and Loops

Excel Spreadsheet Loops

Spreadsheets and Loops This workflow shows how to append additional sheets to an existing spreadsheet with a loop using KNIME Ana…

knime > KNIME for Spreadsheet Users > Spreadsheets and Loops

1

Workflow

Time-over-Time Analysis

In this example, we perform a Time-over-Time analysis using a handful of KNIME nodes. Taking as input the Olympics Games Medals b…

knime > KNIME for Spreadsheet Users > Time-over-Time Analysis

0

Workflow

Prediction within Spreadsheets

Excel Spredsheets Prediction

+1

This workflow shows how to load and prepare data for training a predictive model using some excel files. All data are stored alre…

knime > KNIME for Spreadsheet Users > Prediction within Spreadsheets

1

Nodes for data access

Accelerate your data access with KNIME's comprehensive suite of data access nodes - the fastest, most efficient way to connect to and retrieve data from a wide range of sources.

Reading

This node reads Excel files (xlsx, xlsm, xlsb, and xls format). It can read a single or multiple files at the same time, however reading only one sheet per file. The supported Excel types that can be… Learn more

Google Sheets Reader

This node reads a tab ("sheet") of a Google spreadsheet. The spreadsheet can be selected from the spreadsheets available on Google Drive. Optionally, a specific range can be read from the sheet. The … Learn more

Writing

This node writes the input data table into a spreadsheet of an Excel file, which can then be read with other applications such as Microsoft Excel. The node can create completely new files or append d… Learn more

Google Sheets Writer

This node writes the input data table to a new Google Sheets spreadsheet. If you want to overwrite or append data to an existing sheet, you cannot use the Google Sheets Writer node; you must use the … Learn more

Connecting to services

Microsoft Authenticator

This node provides authentication to access Microsoft Azure and Office 365 cloud services. It supports these authentication modes: Interactive authentication : Performs an interactive user login in y… Learn more

SharePoint Online Connector

This node connects to a SharePoint Online site. The resulting output port allows downstream nodes to access the document libraries of the site as a file system, e.g. to read or write files and folder… Learn more

Google Authenticator

This nodes authenticates to Google services specified in the node settings. Authentication happens in the configuration window. By default, credentials are stored in memory. Custom credentials can be… Learn more

Google Sheets Connector

Creates a connection to Google Sheets, given a Google API connection. When using the Google Authentication (API Key) node to provide the Google API connection, spreadsheets have to be shared with the… Learn more

Nodes for visualizing

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

Stacked Area Chart

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the columns you want to display. Only numeric and text based… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the columns to use for horizontal and vertical dimensions an… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the binning method and enable certain controls, which are th… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can enable certain controls, which are then available in the view. This… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can enable certain controls, which are then available in the view. This… Learn more

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the amount of rows you want to display and enable certain co… Learn more

Parallel Coordinates Plot

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

Scatter Plot Matrix

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

This node displays hierarchical data in a radial layout. The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose inp… Learn more

Nodes for data transformation

Transform your data in sophisticated ways easily possible with KNIME

Aggregating & reshaping

Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns… Learn more

This node uses a user-specified delimiter character to split the content of a selected column into parts. It appends either a fixed number of columns to the input table, each carrying one part of the… Learn more

This node sorts the rows according to user-defined criteria. In the dialog, select the columns according to which the data should be sorted. Also select whether it should be sorted in ascending or de… Learn more

Column Combiner

Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user needs to specify in the dialog the columns of interest and some other prop… Learn more

This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row. Example: Input: Val… Learn more

Moving Aggregator

This node calculates aggregation values for a moving window. The aggregation values are displayed in new columns appended at the end of the table. The columns to aggregate can be either defined by se… Learn more

The Table Splitter splits the input table at the row that matches a given condition. The part of the table that occurred before the matching row is forwarded to the top output table. The bottom outpu… Learn more

Extract a single cell from the input table and output it as a 1x1 table. A flow variable containing the value of the cell will also be created. Learn more

Value creation

This node evaluates a mathematical expression based on the values in a row. The computed results can be either appended as new column or be used to replace an input column. Available variables are th… Learn more

String Replacer

This node replaces strings in a selected target column. In the configuration dialog, a pattern and a replacement text are specified. If the pattern doesn't match, the result string equals the input s… Learn more

String Replacer (Dictionary)

This node replaces strings in selected columns. The dictionary table provides the patterns to search for and the values to replace matches with. If no pattern matches, the result string equals the in… Learn more

Update a single cell of the input table with the value of the specified flow variable. The output table will be identical to the input table except for the single updated cell. Learn more

Merging

This node concatenates two tables. The table at inport 0 is given as the first input table (top input port), the table at inport 1 is the second table, resp. Columns with equal names are concatenated… Learn more

The node has two inputs: a data table and a dictionary table. From the data table select the column that is used to look up values in the dictionary table. From the dictionary table select a column t… Learn more

This node combines two tables similar to a join in a database. It combines each row from the top input port with each row from the bottom input port that has identical values in selected columns. Row… Learn more

Column Appender

The Column Appender takes two or more tables and quickly combines them by appending their columns according to the order of the tables at the input ports. It simply appends columns from the second in… Learn more

Filtering

The node allows for row filtering according to certain criteria. It can include or exclude: certain ranges (by row number), rows with a certain row ID, and rows with a certain value in a selectable c… Learn more

This node allows columns to be filtered from the input table while only the remaining columns are passed to the output table. Within the dialog, columns can be moved between the Include and Exclude l… Learn more

Top k Row Filter

The node behaves the same as a combination of the Sorter node followed by a Row Filter that only keeps the first k rows of the table except for the order of the rows which depends on the Output order… Learn more

Crops part of the input table based on the chosen column and row range. Learn more

Cleaning

This node helps handle missing values found in cells of the input table. The first tab in the dialog (labeled "Default") provides default handling options for all columns of a given type. These setti… Learn more

Duplicate Row Filter

This node identifies duplicate rows. Duplicate rows have identical values in certain columns. The node chooses a single row for each set of duplicates ("chosen"). You can either remove all duplicate … Learn more

Merges two columns into one by choosing the cell that is non-missing. The configuration dialog allows you to choose a primary and a secondary column. The output of the node will be a new column (or a… Learn more

Renames columns according to the renaming scheme defined in the dialog. Column names must be unique, hence it is not possible to give two columns the same name. Learn more

Type conversion

String To Number

Converts strings in a column (or a set of columns) to numbers. If the node fails to parse a string, it will generate a missing cell and append a warning message to the KNIME Console with detailed inf… Learn more

String to Date&Time

Parses the strings in the selected columns and converts them into Date&Time cells. The expected format can be selected from a number of commonly used formats or specified manually (see section "Type … Learn more

Date & time handling

Extract Date&Time Fields

Extracts the selected fields from a Local Date, Local Time, Local Date Time or Zoned Date Time column and appends their values as corresponding integer or string columns. Learn more

Date&Time Shift

The node shifts a date or time with a defined duration or granularity. The user can select the Date&Time columns to shift and the shift value. The shift value can be achieved by using either a durati… Learn more

Cheat sheet: KNIME for spreadsheet users

Use this cheat sheet, designed as a companion just for KNIME Analytics Platform Version 5, as a quick reference for the most popular nodes and their purpose.

Access cheat sheet

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland

Software
Getting started
Documentation
E-Learning course
Solutions

KNIME Hub
KNIME Forum
Blog
Events

Partner
Developers

KNIME Home
KNIME Open Source Story
Careers
Contact us

Download KNIME Analytics Platform Read more on KNIME Business Hub

© 2023 KNIME AG. All rights reserved.

Trademarks
Imprint
Privacy
Terms & Conditions
Credits