Hub
Pricing About
ComponentComponent

Related Column Comparator

ajackson profile image
Draft Latest edits on 
Jun 20, 2025 10:07 PM
Drag & drop
Like
Use or download

Andrew Jackson 2025-06-20

This compares all columns from Table1 against all columns for Table2.

If matches are found for rows then they are counted for both.

This is designed to help search for possible primary keys between two database tables.

The higher the number the more matches have been found and the more likely it is to be related.

Note that small numbers and dates may be misleading.

Columns with no matches are not included in the results.

Datatypes between string/number don't see to matter.

Component details

Input ports
  1. Type: Table
    Table1
    No description available
  2. Type: Table
    Table2
    No description available
Output ports
  1. Type: Table
    Frequencies
    No description available

Used extensions & nodes

Created with KNIME Analytics Platform version 5.4.4
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.4

    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.1

    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.4

    knime
  • Go to item
    NodePit Power NodesUnknown extension

    This is an unpublished or unknown extension.

    Philipp Katz, Daniel Esser; nodepit.com

    Version 1.4.2

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits