Icon

05_​TableDifference_​Finder

Table Difference 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 are capitalized
- positions of age and workclass columns are swapped
The Table Difference Finder node checks the differences between the original data and modified data.
It produces two tables:
- first one is a row-by-row comparison of the entire tables, and shows the difference in capitalized columns
- second one is a comparison of domain differences. The swapped position of age and workclass columns is marked as false in the Position Equals column.

This workflow shows Table Difference Finder node for Original data and Modified data.For more information see the workflow metadata. Find it here: View -> Description Modified data Original data Output 1: diff capitalized columnsOutput 2: Postion Equals false for swapped columnsRead dataadult.csvCapitalize all String type columnsSwap positionage and workclass column Table DifferenceFinder File Reader String Manipulation(Multi Column) Column Resorter This workflow shows Table Difference Finder node for Original data and Modified data.For more information see the workflow metadata. Find it here: View -> Description Modified data Original data Output 1: diff capitalized columnsOutput 2: Postion Equals false for swapped columnsRead dataadult.csvCapitalize all String type columnsSwap positionage and workclass column Table DifferenceFinder File Reader String Manipulation(Multi Column) Column Resorter

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Daria
Created at: 2020-07-12
On NodePit since: 2025-02-18
Last update: 2026-07-13
Created with KNIME version: v4.2.0
Tags: ETLdata manipulationstring manipulationtable difference finder

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!