Compare Two Tables – KNIME Community Hub

KCH Workflows
1

This workflow compares 2 tables with same structure meaning they have same number of columns and matching columns have same names and types. Comparison is done in a loop using Column Comparator node. In each loop iteration two columns are compared and and additional column with values TRUE or FALSE is created.

This is a companion discussion topic for the original entry at https://hub.knime.com/-/spaces/-/latest/~xU8aDokP89N2Y59x/
2

If we have 3 tables/sheets to be compared, what changes would be required in the above workflow?

Table 3 Column 1 can be either compared to column 1 of Table1 or Column #1 of Table 2.

4

@ipazin Could you help me here

5

Hello @itsjasmeet,

give Table Difference Finder node a try. At the time I was building this workflow this node did not exist.

Welcome to KNIME Community!

Br,
Ivan

1 Like