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!
\n \n \n ","shortDescription":"The node matches all subsets of the first input table with all sets of the second input table.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Transform"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RjU5OUYxMUM4OUU4MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RjU5OUYxMUI4OUU4MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo1Qjk3RkExNjM4NEExMUU1OTk3MThDMzA3QzdERDI0QyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo1Qjk3RkExNzM4NEExMUU1OTk3MThDMzA3QzdERDI0QyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pt1fWNAAAABpSURBVHjaYvz//z8DIyPjfwbiACOMAdIHFoAZABPAqZORkTYGsDCQAKTEpAWQuB/wugBqI+FAwWdAx41XcH6FhhgDNjVMDBSCUQOQYoEYxdhiAWYAhgJiUyeKAcg20dcAHJJEhQtAgAEA+aNZVJDO2fwAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Subsets","description":"Subsets."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Sets","description":"Sets to search in."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Matching sets","description":"Matching sets."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Subset column","description":"The column that contains the subsets to search for.","optional":false},{"name":"ID column","description":"The id of the set to search in.","optional":false},{"name":"Set column","description":"The column that contains sets to search in","optional":false},{"name":"Append set column","description":"The matching set is appended if this option is ticked. A new row is created for each matching set.","optional":false},{"name":"Maximum mismatches","description":"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 where only sets match that contain all items of the subset.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.16},{"id":"*wiIVn14C9BeYBHqr","factoryName":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","probability":0.09333333333333334},{"id":"*hI8TzZUNeTUVzkA5","factoryName":"org.knime.base.node.preproc.setoperator.SetOperatorNodeFactory","probability":0.05333333333333334},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.04},{"id":"*Rj5vxjLi7FjrFN15","factoryName":"org.knime.base.node.preproc.matcher.SubsetMatcherNodeFactory","probability":0.04},{"id":"*IFxccsQELocGGQWE","factoryName":"org.knime.base.node.preproc.discretization.caim2.modelcreator.CAIMDiscretization2NodeFactory","probability":0.04},{"id":"*1Uo48m8MIHW-seLx","factoryName":"org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2","probability":0.04},{"id":"*fPwFWApWDkrJLho6","factoryName":"org.knime.base.node.mine.subgroupminer.SubgroupMinerFactory2","probability":0.04},{"id":"*1eEd7ez8QADlHs0e","factoryName":"org.knime.base.node.switches.endif.EndifNodeFactory","probability":0.04},{"id":"*zWvGlU7Na_JlXhi6","factoryName":"org.knime.base.node.meta.looper.LoopEnd2NodeFactory","probability":0.02666666666666667}]}