{"title":"Column Comparator","nodeType":"Manipulator","id":"*vy_dP5yr5m6ZVMPE","factoryName":"org.knime.base.node.preproc.colcompare.ColumnComparatorNodeFactory","factoryId":"org.knime.base.node.preproc.colcompare.ColumnComparatorNodeFactory","path":["Manipulation","Column","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Compares the cell values of two selected columns row-wise. A number of different comparison methods are available: equal, not_equal, less, greater, less_equal, and greater_equal. A new column is appended holding either the left or right column value, a missing cell, or a user specified tag. The type of the appended column depends on the selected content: If a user defined tag is selected, the result column is of type string, in all other case the type is determined by the type of the selected columns.</p>\n        ","shortDescription":"Compares the cell values of two columns row-wise using different comparison methods. A new column is\n    appended with the result of the comparison.","keywords":[],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RDEzNzMyQ0IxODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RDEzNzMyQ0ExODM0MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+B8qIuAAAAN9JREFUeNqUU9sKwjAMTUWLIHtWnM5d/M/1SxVEwedtglsfajNb7EY6uwOhWZZbTxq238YKCDyed6bR60opiHcH0g8wwRj5qWgxyAJ1YxugL04lMAArJomiEixhAvoKwqjC60R1kCV5i0VdSY9ZF9SBEAKutwvXPwd2KeUKSXW5ITuwFd3poG6+/3fgVGBW0SPsz7Iswzj4NfPtJNpEb82BnD0FHQh1U0H9qtdVU5EPaUEZi/Tc4akDGYprC0pAkOeFLwEniOWUo4+Dzi7UyMZnXSEEbGqdzT5MrvNHgAEAb8MUs3Vmxl4AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input","description":"Arbitrary input data."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input with comparison column","description":"Input data plus comparison column."}],"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":"Left column","description":"Left column selected for comparison.","optional":false},{"name":"Operator","description":"Comparison is done based on the selected operator option.\n<ul><li><b>Equals</b> : Tests if both cell values are equal.</li><li><b>Not equals to</b> : Tests if both cell values are not equal.</li><li><b>Less than</b> : Tests if the left cell value is less than the right cell value.</li><li><b>Less or equal than</b> : Tests if the left cell value is less than or equal to the right cell value.</li><li><b>Greater than</b> : Tests if the left cell value is greater than the right cell value.</li><li><b>Greater or equal than</b> : Tests if the left cell value is greater than or equal to the right cell value.</li></ul>","optional":false},{"name":"Right column","description":"Right column selected for comparison.","optional":false},{"name":"Operator result 'true'","description":"Depending on the result of the selected operator, a certain value is set into the new column. Select one of the following options for the operator result &#39;true&#39;.\n<ul><li><b>Left value</b> : The value of the left column is set in the result column.</li><li><b>Right value</b> : The value of the right column is set in the result column.</li><li><b>Missing</b> : A missing cell is set in the result column.</li><li><b>User-defined</b> : The text entered in the &#39;Tag&#39; field is set in the result column.</li></ul>","optional":false},{"name":"Tag","description":"The text to set in the result column when the operator result is &#39;true&#39;.","optional":false},{"name":"Operator result 'false'","description":"Depending on the result of the selected operator, a certain value is set into the new column. Select one of the following options for the operator result &#39;false&#39;.\n<ul><li><b>Left value</b> : The value of the left column is set in the result column.</li><li><b>Right value</b> : The value of the right column is set in the result column.</li><li><b>Missing</b> : A missing cell is set in the result column.</li><li><b>User-defined</b> : The text entered in the &#39;Tag&#39; field is set in the result column.</li></ul>","optional":false},{"name":"Tag","description":"The text to set in the result column when the operator result is &#39;false&#39;.","optional":false},{"name":"Output column name","description":"Name of the output column.","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":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.2222222222222222},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.08061002178649238},{"id":"*vy_dP5yr5m6ZVMPE","factoryName":"org.knime.base.node.preproc.colcompare.ColumnComparatorNodeFactory","probability":0.06100217864923747},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.0457516339869281},{"id":"*C-nR3bKHp4paQHZK","factoryName":"org.knime.base.node.preproc.filter.row.RowFilter2PortNodeFactory","probability":0.04357298474945534},{"id":"*Q-yW-3C9DumtInuz","factoryName":"org.knime.base.node.rules.engine.RuleEngineFilterNodeFactory","probability":0.02832244008714597},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.023965141612200435},{"id":"*cB9KE6SSG6RhNZNp","factoryName":"org.knime.base.node.preproc.valcount.ValueCounterNodeFactory","probability":0.02178649237472767},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.02178649237472767},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.0196078431372549}]}