Subset Matcher

The node matches all subsets of the first input table with all sets of the second input table. The result table contains pairs of matching subsets and sets. The node can be used to find all transactions that match a given list of item sets.

Fuzzy matching: At least one item has to match from the subset!

Options

Subset column: The column that contains the subsets to search for
ID column: The id of the set to search in.
Set column: The column that contains sets to search in
Append set column: The matching set is appended if this option is ticked. A new row is created for each matching set.
Maximum mismatches: The maximum number of allowed mismatches, e.g. 1 allows for one item of the subset to be missing in the set. Default value is 0 were only sets match that contain all items of the subset.

Input Ports

: Subsets
: Sets to search in

Output Ports

: Matching sets

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.3.v202410291553

On NodePit since: 2024-07-09

Last update: 2024-11-21

KNIME versions: Since v3.6

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

Try NodePit Runner!