{"title":"Reference Row Splitter","nodeType":"Manipulator","id":"*LaMrKSen-Or6SfMS","factoryName":"org.knime.base.node.preproc.filter.rowref.RowSplitRefNodeFactory","factoryId":"org.knime.base.node.preproc.filter.rowref.RowSplitRefNodeFactory","path":["Manipulation","Row","Filter"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node allows rows to be split from the first table using the second table as reference. Rows which are available in both the input table and the reference table will be written into the table of the first output port. All others in the second one.</p>\n        ","shortDescription":"The Reference Row Splitter allows rows to be split from the first table using the second table as reference.","keywords":["filter"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Filter","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQBAMAAAGa2tLEAAAAIVBMVEX8/vwULlQsPmQkOlwA5u38/uwA5gAAgv8AfAAEBiwEAgQNoRy3AAAAAXRSTlMAQObYZgAAAFdJREFUCJljYAADVgY4YGFgaGBlSICwGDgYIEQCAxIoMAARExgY0hjYC4AshnAgH8RCAuwMjCCqvLy8hAkskMDOwAVSk9GRABQEamJoAMmmFUAMR9MOAQCd3g6gSA7lywAAAABJRU5ErkJggg==","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"The input table"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Reference table","description":"The reference table"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Matching rows","description":"The rows that match the reference table"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Non-matching rows","description":"The rows that do not match the reference table"}],"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":"Data column (in first input)","description":"The column from the table to be split that should be used for comparison.","optional":false},{"name":"Reference column (in second input)","description":"The column from the filter table that should be used for comparison.","optional":false},{"name":"Update domains of all columns","description":"Advanced setting to enable recomputation of the domains of all columns in the output table such that the domains&#39; bounds exactly match the bounds of the data in the output table.","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":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.10643185298621746},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.10566615620214395},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.08958652373660031},{"id":"*LaMrKSen-Or6SfMS","factoryName":"org.knime.base.node.preproc.filter.rowref.RowSplitRefNodeFactory","probability":0.0666156202143951},{"id":"*6CbObXLq9oHq_EFi","factoryName":"org.knime.base.node.preproc.constantvalue.ConstantValueColumnNodeFactory","probability":0.03828483920367534},{"id":"*LKxrCJihG46anH0Q","factoryName":"org.knime.base.node.preproc.filter.rowref.RowFilterRefNodeFactory","probability":0.03751914241960184},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.036753445635528334},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.03139356814701378},{"id":"*C-nR3bKHp4paQHZK","factoryName":"org.knime.base.node.preproc.filter.row.RowFilter2PortNodeFactory","probability":0.02986217457886677},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.026033690658499236}]}