Collection
KNIME Analytics Platform Version 5 Starter Perspective Collection
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.
Go to item
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
Go to item
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
Go to item
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
Go to item
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
Go to item
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.
Go to item
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
Go to item
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
Go to item
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
Go to item
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
Go to item
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.
Go to item
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
Go to item
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
Go to item
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
Go to item
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
Writing
Connecting to services
Nodes for visualizing
Nodes for data transformation
Transform your data in sophisticated ways easily possible with KNIME
Aggregating & reshaping
Value creation
Merging
Filtering
Cleaning
Type conversion
Date & time handling
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.