Icon

KNIME for Spreadsheet Users

This directory contains 15 workflows.

IconCalculate Totals (Multiple Files) 

This workflow shows how to calculate the totals of multiple files using KNIME Analytics Platform. The aim is to concatenate the input tables (same […]

IconCharts and Spreadsheets 

This workflow shows how to create charts from spreadsheet data and add them to a new spreadsheet using KNIME Analytics Platform. The aim is to preprocess […]

IconCountIf and SumIf 

This workflow shows how to perform a SumIf and a CountIf function in KNIME Analytics Platform. Of course, there are different ways to get this done using […]

IconCreate and Send 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 is to automatically send […]

IconJoin Strings (Multiple Sheets) 

This workflow shows how to concatenate tables from two different sheets and combine string-type columns using KNIME Analytics Platform. The aim is to […]

IconJoining Spreadsheets 

In this workflow, we see how to use the Joiner node to clean up a dataset using KNIME Analytics Platform. Sometimes more than a VLOOKUP is needed. You may […]

IconMerge Files 

This workflow merges different unstructured data sources to come up with a new table. Since data come from different data files, we need to blend […]

IconNon-standard format Spreadsheets 

This workflow shows how to work with spreadsheets that come in a non-standard format using KNIME Analytics Platform. The aim is to clean up and rearrange […]

IconPivot Table 

A pivot table aims to arrange a table so that other stakeholders can easily share and understand data. Let's walk through the different nodes involved in […]

IconPrediction within Spreadsheets 

This workflow shows how to load and prepare data for training a predictive model using some excel files. All data are stored already within the workflow […]