Performs set operations on two table columns. The available set operations are:
Intersection
Union
Complement
Exclusive-or
\n \n \n ","shortDescription":"Performs a set operation on two selected table columns.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Transform"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6OEY2NDNERTI4OUY2MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6OEY2NDNERTE4OUY2MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBNEEwMEQzMDE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBNEEwMEQzMTE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pmf3yhIAAAHySURBVHjaYvz//z8DJYCJgUJAsQHIwB6I9wLxDyAG+esyEKdB8WWo2A+oGnuYJmYoncnIwLA4WEb2Y6+BIXu8guJ3UQ72j8ffvk0Eynknpsu+yCtTYvYOEPv25fOfnw/vfy8Gir8F4jMsQMIUqLl3lZX1G2sREROYyTtfvHjOzsbwGuRNdg4mRjUNblGQeHOPhsTRg+/ul+dd7wUZAAqDMm8pqatAzTIwzX+BMTPx1k25xa3M32bWMn+ZP+OxELJfre2FFG2dhC+B9IIMcMpXVVNEVnD+/fv3/xj/swS5MCpHeTEq//r1T+T5s5+fkdUkpsnIgfSCDBCS5eISRpZ88v3bDzZWhg/MQFlWoCeBXnn3+uXPj8hqpGQ4JEF6QWHw7vmPHwx8rKxwZ8pwcvH+/AX0yj9g0APD/tdvBkF+AdY/yAYAXfQJSP0BuWDf7Ht37yFLGggK8jAzMP5ZuvX/3ZU7/j9mZGT8LqfAyYesZtmCpw9BekEGdK149Ejt2qePr2CSLIyMDMlKSs/Tm//ypjT+ZQ8Kl3gEFIKDi+c+vd+z/bUKSC8oHTwDuvLjkocPXb/++XNNkpOT/en371+vfvr45dSb94p//jJwBIVLfhWXZBf4+uXvv4Wzn1zrarojAvRaCVDvRopTIuOA50aAAAMAd8jDcWtuAW0AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"First input table","description":"Contains the column whose values are used as the first set."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Second input table","description":"Contains the column whose values are used as the second set."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Result output table","description":"The output table contains a single column with the result of the set operation."}],"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":"First set","description":"The column of the first data input table which contains the elements of the first set.","optional":false},{"name":"Operation","description":"The set operation to perform on the selected sets.\n
Intersection : The intersection of the two sets.
Union : The union of the two sets.
Complement : The complement of the second set to the first set.
Exclusive-or : The symmetric difference of the two sets.
","optional":false},{"name":"Second set","description":"The column of the second data input table which contains the elements of the second set.","optional":false},{"name":"Skip missing values","description":"All missing values will be skipped during computation thus the result set contains no missing value elements.","optional":false},{"name":"Enable hiliting","description":"If enabled, the hiliting of a set entry row will hilite all rows of this set entry in other views. Depending on the number of rows, enabling this feature might consume a lot of memory.","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.24347826086956523},{"id":"*LKxrCJihG46anH0Q","factoryName":"org.knime.base.node.preproc.filter.rowref.RowFilterRefNodeFactory","probability":0.1826086956521739},{"id":"*hI8TzZUNeTUVzkA5","factoryName":"org.knime.base.node.preproc.setoperator.SetOperatorNodeFactory","probability":0.07391304347826087},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.06086956521739131},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.034782608695652174},{"id":"*Rj5vxjLi7FjrFN15","factoryName":"org.knime.base.node.preproc.matcher.SubsetMatcherNodeFactory","probability":0.034782608695652174},{"id":"*NEtdObxjUs6xOdsw","factoryName":"org.knime.ext.sun.nodes.script.JavaScriptingNodeFactory","probability":0.030434782608695653},{"id":"*LWyum507SBwIYcO8","factoryName":"org.knime.ext.itemset.nodes.learner.AssociationRuleLearnerNodeFactory","probability":0.017391304347826087},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.017391304347826087},{"id":"*d25EcU2lz6RoE3gB","factoryName":"org.knime.base.node.meta.looper.chunk.LoopStartChunkNodeFactory","probability":0.017391304347826087}]}