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.
Nodes
- CSV Writer1 ×
- Column Auto Type Cast1 ×
- Column Resorter1 ×
- File Reader1 ×
- String Manipulation (Multi Column)1 ×
- Table Difference Finder1 ×