{"title":"Many to One (PMML)","nodeType":"Manipulator","id":"*pu1W2Sq3367PuKdk","factoryName":"org.knime.base.node.preproc.pmml.columntrans2.Many2OneCol2PMMLNodeFactory2","factoryId":"org.knime.base.node.preproc.pmml.columntrans2.Many2OneCol2PMMLNodeFactory2","path":["Manipulation","PMML"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Transforms the values of multiple columns into a single column depending on the include method and documents the transformation in PMML. If set to binary the condensed column&#39;s value is set to the name of the first column with value 1. If the include method is maximum or minimum the value of the condensed column is set to the name of the column which, of all included columns, has the largest or smallest value. If the include method is binary and all columns are 0 the condensed column will contain a missing value.</p>\n        ","shortDescription":"Transforms the values of multiple columns into a single column while generating PMML.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","PMML"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RTFCOTkwOTE4N0M0MTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RTFCOTkwOTA4N0M0MTFFNUIyNjBENUZBOEI3RjgwMEUiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBRDRFODZGNzE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBRDRFODZGODE4MzQxMUU1ODEzQUUwRDBBNzRDODlBMiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PtCLsZcAAACWSURBVHjapFPBDYAgDGyb/h3ImRzCGZzJgZwAbUK1FoQaLiE2B9zhFRgA0gWwQESIcgSDIK/o0eOGT8BeUesoR1cwqEPn/nBkFDXiZBy7nM1gdd8YJ701/X2KIOe7gJWgmxxV1PX/Una6h3B2ndT82pUnJZxjmwvbadkLM4rcvBaw9kBsSL09/OXuhWs3UtYMv4VTgAEAQe5mK6ThC58AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data to process","description":"Data."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Processed data","description":"Data with transformed columns."},{"objectClass":"org.knime.core.node.port.pmml.PMMLPortObject","color":"1469af","dataType":"PMML","optional":false,"name":"Created PMML","description":"Transformed PMML input."}],"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":"Columns","description":"The columns to be condensed into a single column using the selected include method.","optional":false},{"name":"Condensed column name","description":"The name of the appended column.","optional":false},{"name":"Include method","description":"The method to condense multiple columns into one.\n<ul><li><b>Binary</b> : Only the column with value &#34;1&#34; matches.</li><li><b>Maximum</b> : The column with the maximum value in each row matches.</li><li><b>Minimum</b> : The column with the minimum value in each row matches.</li><li><b>RegExpPattern</b> : The column matching the provided regular expression pattern matches.</li></ul>","optional":false},{"name":"Include pattern","description":"When include method is RegExpPattern, this is the pattern used.","optional":false},{"name":"Keep original columns","description":"Determines whether the included columns are kept or not.","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":"*1QQFxIzeu9KVOVPZ","factoryName":"org.knime.base.node.preproc.pmml.columnfilter.DataColumnSpecFilterPMMLNodeFactory","probability":0.5},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.5}]}