{"title":"Many to One","nodeType":"Manipulator","id":"*XbOgJJl-gFiDMtr1","factoryName":"org.knime.base.node.preproc.columntrans2.Many2OneCol2NodeFactory","factoryId":"org.knime.base.node.preproc.columntrans2.Many2OneCol2NodeFactory","path":["Manipulation","Column","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Aggregates several columns into one single column.\n <br />\n In each row, it finds a matching column from the set of selected columns and places the name of that matching column into the aggregated result column. Which column matches depends on the selected &#34;Include method&#34; and the include pattern.\n <br />\n If no column matches a missing value is added. If multiple columns match execution fails and no output is generated.\n <br />\n Missing values in the selected columns are ignored. If all selected columns of one row consist of missing values a missing value is put in the aggregated column. All include methods except the regular expression require columns which are double compatible.</p>\n        ","shortDescription":"Aggregates several columns into one single column.","keywords":[],"deprecated":false,"streamable":false,"tags":["Manipulation","Column","Transform"],"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 aggregated 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":"Columns to aggregate","description":"Select those columns which should be condensed into the aggregated result column.","optional":false},{"name":"Appended column name","description":"Name of the aggregate column that will be created.","optional":false},{"name":"Include method","description":"Choose the method to determine the matching column:\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":"Enter the regular expression pattern if RegExpPattern was chosen as include method.","optional":false},{"name":"Keep original columns","description":"If checked, the selected columns are kept in the output table, otherwise they are deleted.","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":"*XbOgJJl-gFiDMtr1","factoryName":"org.knime.base.node.preproc.columntrans2.Many2OneCol2NodeFactory","probability":0.08064516129032258},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.04838709677419355},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.04838709677419355},{"id":"*uVmaGQkzUOFCTqUe","factoryName":"org.knime.base.node.preproc.pmml.missingval.compute.MissingValueHandlerNodeFactory","probability":0.03225806451612903},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.03225806451612903},{"id":"*CCMhDNWHYFXV506q","factoryName":"org.knime.base.node.meta.looper.LoopEndJoin2NodeFactory","probability":0.03225806451612903},{"id":"*wiIVn14C9BeYBHqr","factoryName":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","probability":0.03225806451612903},{"id":"*20rIDLuYXD4U8cnN","factoryName":"org.knime.base.node.preproc.colconvert.stringtonumber.StringToNumberNodeFactory","probability":0.03225806451612903},{"id":"*ZGTqWYyk_JhsxQTj","factoryName":"org.knime.ext.poi.node.write2.XLSWriter2NodeFactory","probability":0.03225806451612903},{"id":"*SMkaasH0Wn3tKqfo","factoryName":"org.knime.base.node.mine.scorer.accuracy.AccuracyScorerNodeFactory","probability":0.03225806451612903}]}