Icon

KNIME for Spreadsheet Users

This directory contains 15 workflows.

IconCalculate Totals - Multiple Files 

<p><strong>Calculate Totals - Multiple Files</strong></p><p>This workflow shows how to calculate the totals of multiple files using KNIME Analytics […]

IconCharts and Spreadsheets 

<p><strong>Charts and Spreadsheets</strong></p><p>This workflow shows how to create charts from spreadsheet data and add them to a new sheet.</p><p>The aim […]

IconConcatenate Tables and Combine String Cells 

<p><strong>Concatenate Tables and Combine String Cells</strong></p><p>This workflow shows how to concatenate data tables from two different sheets and how […]

IconCountIf and SumIf 

<p><strong>CountIf and SumIf</strong></p><p>This workflow shows how to perform a <strong>SumIf </strong>and a <strong>CountIf </strong>function using KNIME […]

IconCreate and Send Report 

<p><strong>Create and Send a Report</strong></p><p>In this workflow, we see how to build and send a report via email using KNIME Analytics […]

IconCreating a Pivot Table 

<p><strong>Creating a Pivot Table</strong></p><p>A pivot table aims to arrange a table so that other stakeholders can easily share and understand data. This […]

IconJoin and Clean Spreadsheets 

<p><strong>Join and Clean Spreadsheets</strong></p><p>In this workflow, we see how to join two datasets and how to clean up a table using KNIME Analytics […]

IconMerge Files 

<p><strong>Merge Files - Unstructured Data</strong></p><p>This workflow merges different unstructured data sources to create a new table.</p><p>Data often […]

IconNon-standard format Spreadsheets 

<p><strong>Non-standard Spreadsheet Formats</strong></p><p>This workflow shows how to work with spreadsheets that come in a non-standard format using KNIME […]

IconPrediction within Spreadsheets 

<p><strong>Prediction within Spreadsheets</strong></p><p>This workflow shows how to load and prepare data for training a predictive model using data from […]