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
Popular Predecessors
Cell Splitter9 %- Create Bit Vector6 %
File Reader5 %- Cell Splitter5 %
- Association Rule Learner3 %
- GroupBy3 %
- Java Snippet Row Filter3 %
- Rule-based Row Filter2 %
Excel Reader (XLS)2 %- Excel Reader2 %
- Create Collection Column2 %
- String Manipulation2 %
Row Filter (deprecated)1 %- Column Filter1 %
Joiner1 %- Column Appender1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Cross Joiner< 1 %
- Partitioning< 1 %
- Math Formula< 1 %
- Table Reader< 1 %
- Concatenate< 1 %
- Pivot< 1 %
- Sorter< 1 %
- Java Snippet (simple)< 1 %
- String to Number< 1 %
Table Reader< 1 %Column Appender< 1 %- Subset Matcher< 1 %
- Column Auto Type Cast< 1 %
- Joiner< 1 %
- Boolean Configuration< 1 %
- Empty Table Creator< 1 %
- Split Collection Column< 1 %
CSV Reader< 1 %Number To String< 1 %String To Number< 1 %Row Splitter (deprecated)< 1 %- RowID< 1 %
- Ungroup< 1 %
- Duplicate Row Filter< 1 %
- Date&Time-based Row Filter< 1 %
- CSV Reader< 1 %
- Rank< 1 %
- Table Creator< 1 %
- Case Converter< 1 %
- Column Aggregator< 1 %
- Normalizer< 1 %
- Missing Value< 1 %
Column Rename< 1 %- Row Sampling< 1 %
- Set Operator< 1 %
- Rule Engine< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Item Set Finder (Borgelt)< 1 %
- String to Date&Time< 1 %
- Group Loop Start< 1 %
- Number to String< 1 %
- One to Many< 1 %
- End IF< 1 %
- Math Formula (Multi Column)< 1 %
- List To Set< 1 %
- Table Manipulator< 1 %
- Column Expressions< 1 %
- Linear Correlation< 1 %
- Column Renamer< 1 %
- Many to One< 1 %
- Column Splitter< 1 %
- Rule-based Row Splitter< 1 %
Strings To Document< 1 %- Double to Integer< 1 %
- Table to JSON< 1 %
Table Row To Variable Loop Start< 1 %- ARFF Reader< 1 %
- Cell Splitter By Position< 1 %
- SDF Reader< 1 %
Excel Reader (XLS)< 1 %- String Matcher< 1 %
- Document Vector< 1 %
- Term Vector< 1 %
Table Row to Variable< 1 %String Replace (Dictionary)< 1 %- Column Filter Configuration< 1 %
List Files< 1 %Loop End< 1 %- Cluster Assigner< 1 %
- Column Resorter< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Value Counter< 1 %
Rank Correlation< 1 %XLS Reader< 1 %- SMOTE< 1 %
- Category to Number< 1 %
- Create Table Structure< 1 %
- Normalizer (Apply)< 1 %
- Many to One (PMML)< 1 %
- Data Generator< 1 %
- XPath< 1 %
- Silhouette Coefficient< 1 %
- Unpivot< 1 %
Database Connection Table Reader< 1 %Database Reader< 1 %Line Reader< 1 %- Chunk Loop Start< 1 %
- Distance Matrix Pair Extractor< 1 %
- Bootstrap Sampling< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
- Statistics< 1 %
- k-Medoids< 1 %
- Similarity Search< 1 %
Excel Reader (XLS)< 1 %- Java IF (Table)< 1 %
- Value Selection (legacy)< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- SubGraph Extractor< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit Molecule Substructure Filter< 1 %
- Benchmark Start< 1 %
- Benchmark Start (Memory Monitoring)< 1 %
- Plate Heatmap Viewer< 1 %
- Breakpoint< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %- Fixed Width File Reader< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Counting Loop Start< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %Variable Loop End< 1 %- Fuzzy Rule Predictor< 1 %
- PNN Learner (DDA)< 1 %
- PNN Predictor< 1 %
- Hierarchical Clustering< 1 %
- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Lag Column< 1 %
- Column Merger< 1 %
- Table Validator< 1 %
- Interactive HiLite Collector< 1 %
- Reference Row Splitter< 1 %
- Denormalizer< 1 %
- Missing Value (Apply)< 1 %
Number To String (PMML)< 1 %- Reference Column Resorter< 1 %
- Table Transposer< 1 %
- Ruleset to Table< 1 %
- IF Switch< 1 %
- Extract Table Spec< 1 %
- Box Plot (legacy)< 1 %
Color Appender< 1 %- Parallel Chunk Start< 1 %
- DB Query Reader< 1 %
- Beta Distributed Assigner< 1 %
- Random Matcher< 1 %
Excel Writer (XLS)< 1 %- TF< 1 %
- Term to String< 1 %
- Column Filter (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Double Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- R to Table< 1 %
- Fingerprints< 1 %
- RDKit Optimize Geometry< 1 %
- Set To List< 1 %
- File Reader< 1 %
- File Reader (Complex Format)< 1 %
- Number to String (PMML)< 1 %
- String Splitter (Regex)< 1 %
- String Replacer< 1 %
- Files/Folders Meta Info< 1 %
- List Box Configuration< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
Views
- This node has no views
Workflows
02_Apply_Association_Rules_for_MarketBasketAnalysisKNIME Hub- 02_Apply_Association_Rules_for_MarketBasketAnalysisKNIME Hub
- 02_Apply_Association_Rules_for_MarketBasketAnalysisKNIME Hub
- 02_Apply_Association_Rules_for_MarketBasketAnalysisKNIME Hub
- 02_Apply_Association_Rules_for_MarketBasketAnalysisKNIME Hub
- Show all 75 workflows
Links
- Compare Two Sets [Arrays]by AnotherFraudUser on 2020-05-17forum.knime.com/p/91527
- Check Keyword of Textby armingrudd on 2020-02-27forum.knime.com/p/82826
- Compare if contents of list 1 is a full intersection of contents of list 2by ipazin on 2023-06-20forum.knime.com/p/213602
- Groupby based on substring matchby izaychik63 on 2020-02-15forum.knime.com/p/81669
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.