{"title":"Row Filter","nodeType":"Manipulator","id":"*r8RWEOkU1NAO1cWu","factoryName":"org.knime.base.node.preproc.filter.row3.RowFilterNodeFactory","factoryId":"org.knime.base.node.preproc.filter.row3.RowFilterNodeFactory","path":["Manipulation","Row","Filter"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>The node filters an input table according to the given filter criteria. Each criterion can target the row number, RowID, or cell value of a row. Multiple criteria can be combined (similar to boolean logic via <tt>AND</tt> and <tt>OR</tt> ) to specify the overall filter criterion applied to each row.</p>\n        ","shortDescription":"Allows filtering of data rows based on row numbers, RowID, and cell values.","keywords":["Condition","Predicate","where"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Filter","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6Rjk3QThFRUE0NDFDMTFFNUI4QUY5RjNFOUEzQTE4QjIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6Rjk3QThFRTk0NDFDMTFFNUI4QUY5RjNFOUEzQTE4QjIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpiNmRiZTRmOC00Yzc3LTQyZGUtOGI5NC00ZGExNTM3Y2Q1M2YiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+JOw8vQAAAJVJREFUeNqkUgEKwCAI9KL/f9ll6BCntrGDkEhPu3MwM8WzwBrTuz+DCgDYRStShymJHYmElqBIMNK+/cJo3lBN5b81TZyQdGeoDpFMSNCK6BwwUkpIjiKeJOBBPyEa4EtBmBjzxZiUCW0uVS7sBbI33UpvBtI9kATvYLg/iqVB64JuJLpvpSIaaRg71aMUMSvOcAkwALIaZjL1MMxxAAAAAElFTkSuQmCC","sinceVersion":"5.3.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Table","description":"Data table from which to filter rows"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Included Rows","description":"Data table with rows meeting the specified criterion"}],"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":"Match row if matched by","description":"Match the row if all or any criteria match:\n<ul><li><b>All criteria</b> : a row is matched if <i>all</i> of the criteria match (intersection of matches)</li><li><b>Any criterion</b> : a row is matched if <i>at least one</i> of the criteria matches (union of matches)</li></ul>","optional":false},{"name":"Filter criteria","description":"The list of criteria that should be filtered on.\n<ul><li><b>Filter column</b> : The column on which to apply the filter.\n  <br />\n  The special column &#34;RowID&#34; represents the RowID of the input and is treated as a String column that is never missing. The special column &#34;Row number&#34; targets the 1-based row number of the input, is treated as a Long column and is never missing. Both special columns are always available, regardless of the input table spec or data.\n  <br />\n  <br />\n  Columns containing data types that are non-native, i.e. contain cells of heterogeneous data types, or do not offer a conversion from and to a string representation are not supported and are filtered out from the available options.\n  <br />\n  Collection columns are also not supported by the node.</li><li><b>Operator</b> : Select the filter operator to apply.</li><li><b>Filter value</b> : The value for the filter criterion.\n  <br />\n  <br />\n  <i>Note:</i>Currently, comparison values for non-numeric and non-string data types, e.g. date&amp;time-based types, must be entered as its string representation like in the <a href=\"https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.io.tablecreator.TableCreator2NodeFactory\" rel=\"ugc nofollow noopener noreferrer\"> <i>Table Creator</i> </a> node.\n  <br />\n  The format for date&amp;time-based values is &#34;ISO-8601 extended&#34;. For example, a &#34;Local Date&#34; must be entered in the format &#34;2006-07-28&#34;. More information can be obtained from the ISO patterns in the &#34;Predefined Formatters&#34; table of the <a href=\"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/time/format/DateTimeFormatter.html#predefined\" rel=\"ugc nofollow noopener noreferrer\">Java SE 17 documentation</a> .</li></ul>","optional":false},{"name":"Column domains","description":"Specify whether to take domains of all input columns as output domains as-is or compute them on the output rows.\n<br />\nDepending on the use case, one or the other setting may be preferable:\n<ul><li><em>Retaining</em> input columns can be useful, if the axis limits of a view should be derived from domain bounds, and that bounds should stay stable even when the displayed data is filtered.</li><li><em>Computing</em> domains can be useful when a selection widget consumes the output and should only display actually present options to users.</li></ul>\nIf column domains are irrelevant for a particular use case, the &#34;Retain&#34; option should be used since it does not incur computation costs.\n<br />\nFor more control over individual column domains, you can use the <a href=\"https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.domain.dialog2.DomainNodeFactory\" rel=\"ugc nofollow noopener noreferrer\"> <em>Domain Calculator</em> </a> , <a href=\"https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.domain.editnumeric.EditNumericDomainNodeFactory\" rel=\"ugc nofollow noopener noreferrer\"> <em>Edit Numeric Domain</em> </a> , or <a href=\"https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.domain.editnominal.EditNominalDomainNodeFactory\" rel=\"ugc nofollow noopener noreferrer\"> <em>Edit Nominal Domain</em> </a> nodes.\n<ul><li><b>Retain</b> : Retain input domains on output columns, i.e. the upper and lower bounds or possible values in the table spec are not changed, even if one of the bounds or one value is fully filtered out from the output table. If the input does not contain domain information, so will the output.</li><li><b>Compute</b> : Compute column domains on output columns, i.e. upper and lower bounds and possible values are computed only on the rows output by the node.</li></ul>","optional":false},{"name":"Filter behavior","description":"Determines whether only matching or non-matching rows are output.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:cca53bfb-8d53-421f-aa43-b5263efe36f3","user":"simons","date":"2024-10-21T08:10:58+00:00"},{"accountId":"account:user:0bdd4cfd-e461-4f68-b7f8-1c1ab75d05c2","user":"kevin.kress","date":"2024-10-21T08:11:01+00:00"}],"kudosCount":2,"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":[]}