04_Transformation
This directory contains 11 workflows.
01_Handling_Missing_Values
This workflow demonstrates how to deal with missing values in data tables. They can either be replaced (e.g. by the mean, a specified value etc.) or the […]
02_StringManipulation_MathFormula_RuleEngine
This workflow shows three different data manipulation operations, namely: - create three categories of people based on their weekly work hours with the […]
03_Column_Expressions_for_Data_Manipulation
This is an example worklow to manipulate string values, transform numeric values, and generate new columns using the following: 1. The String Manipulation […]
04_StringManipulation_MultiColumn
This workflow shows three different string manipulation on multiple columns, namely: - capitalize all String type columns - replace "-" with a space in […]
05_TableDifference_Finder
This workflow shows the usage of Table Difference Finder node. A csv file is read in. The data are modified in one branch: - all String type columns […]
06_Multi-Row_Formula_using_Column_Expression
Showcases the use of a new function in the Column Expression node to read data from previous and subsequent rows.
07_File_Path_Expressions
This workflow demonstrates the usage of various path expressions. It first creates a file for all group members. The created files are added to a zip file […]
Anonymize PII in contract data
<p>You can easily download and run the workflow directly in your KNIME installation. We recommend that you use the latest version of the KNIME Analytics […]
Data Manipulation with Expressions and AI assistant
URL: Extension: KNIME AI Assistant https://hub.knime.com/knime/extensions/org.knime.features.ai.assistant/latest/
Dataset cleaning and formatting
This workflow demonstrates how to use the "String Format Manager" node in conjunction with the "Number Format Manager" and "String Cleaner" nodes. The […]