Table Row Mismatch Finder

Compares a set of "key" columns in Table 1 with a set of "key" columns in Table 2 and returns tables showing the matches and differences.

The key columns in each table will be concatenated and compared so prior to calling this component, the columns to be combinaed as a "key" must be present in the same order on both tables.


@takbb Brian Bates 18 Aug 2023

Options

Table 1 Key Columns

Choose all Key Columns for Table 1

Table 2 Key Columns

Choose all Key Columns for Table 2

Nodes

• RowID8 ×
• Constant Value Column3 ×
• Table Row to Variable3 ×
• Column Combiner2 ×
• Column Filter Configuration2 ×
• Concatenate2 ×
• Joiner2 ×
• Column Filter1 ×
• Component Input1 ×
• Component Output1 ×
• Duplicate Row Filter1 ×
• Group Loop Start1 ×
• Loop End1 ×
• Row Filter1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Quick Forms

Links

• No links available