{"title":"Reference Column Filter","nodeType":"Manipulator","id":"*LBLxD9VX3jSsQcU1","factoryName":"org.knime.base.node.preproc.filter.columnref.ColumnFilterRefNodeFactory","factoryId":"org.knime.base.node.preproc.filter.columnref.ColumnFilterRefNodeFactory","path":["Manipulation","Column","Filter"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node allows columns to be filtered from the first table using the second table as reference table. Depending on the dialog setting, either the columns from the reference table are included or excluded in the output table.</p>\n        ","shortDescription":"The Reference Column Filter allows columns to be filtered from the first \n\t\ttable using the second table as reference.","keywords":["Remove columns"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Filter","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6M0EwQTJCQTYxODM1MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6M0EwQTJCQTUxODM1MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+Lx6BhgAAAJpJREFUeNqUk9EOgCAIRYX51P//a48UTdyVUNSNjQhOXDAWkaIWHPHx9izmqzG+d1aISCbwfirQyfy30Dqg5ueAIDEtHgCB1gGsMZUEcmkKgMRiiSazzaXHuGwe7UTNz2UbgCCUeAr4VowStwHtqwR2PoNsjbJo+7eRqIMrayIKIuDG/Tr90yvJwYrIF6+uNAfDYoDU7H94BBgAaL9RLbSKQZ4AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table to be filtered","description":"Table from which columns are to be included or excluded"},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Reference table","description":"Table with the columns used as references"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Filtered table","description":"Table with filtered columns"}],"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":[{"fields":[{"name":"Include or exclude columns from the reference table","description":"Includes or excludes columns that appear in the reference table from the first table.","optional":false},{"name":"Ensure type compatibility","description":"Ensures that the matching columns don&#39;t only have the same name but also the same type. Columns are only included or excluded if the column type of the first table is a super-type of the column type from the second table. If not selected, only the column names need to match.","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.08673978065802593},{"id":"*_zMUh-EpYjdvFKW9","factoryName":"org.knime.base.node.preproc.columnappend.ColumnAppenderNodeFactory","probability":0.06380857427716849},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.03589232303090728},{"id":"*_y-V6DTqskd8w-IM","factoryName":"org.knime.base.node.preproc.binner.BinnerNodeFactory","probability":0.028913260219341975},{"id":"*0rhLXWO6OS1xMi8T","factoryName":"org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory","probability":0.028913260219341975},{"id":"*LBLxD9VX3jSsQcU1","factoryName":"org.knime.base.node.preproc.filter.columnref.ColumnFilterRefNodeFactory","probability":0.027916251246261216},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.0259222333000997},{"id":"*LKxrCJihG46anH0Q","factoryName":"org.knime.base.node.preproc.filter.rowref.RowFilterRefNodeFactory","probability":0.020937188434695914},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.019940179461615155},{"id":"*NmCHLnBIGbvnDkb6","factoryName":"org.knime.base.node.meta.looper.columnlist2.ColumnListLoopStartNodeFactory","probability":0.018943170488534396}]}