{"title":"Column Aggregator","nodeType":"Manipulator","id":"*wiIVn14C9BeYBHqr","factoryName":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","factoryId":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","path":["Manipulation","Column","Split & Combine"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Groups the selected columns per row and aggregates their cells using the selected aggregation method.</p>\n             \n            <p>To change the name of the new created aggregation column double click on the name column.</p>\n             \n            <p>A detailed description of the available aggregation methods can be found on the &#39;Description&#39; tab in the node dialog.</p>\n            \n        \n        ","shortDescription":"Groups the selected columns per row and aggregates their cells using the selected aggregation method.","keywords":["Combine cells","deviation","maximum","correlation","count","mean","minimum","mode","percentile","quantile","range","set","unique"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Split & Combine","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MUMzNUY5NzcxODM1MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MUMzNUY5NzYxODM1MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+ZyQXXQAAAGtJREFUeNrMkdsOwCAIQ2ni//9yN+MljsFwuofxoBGb04oQEYpdyAtZrgHQE7GJehMwAZZuClDP7wBnD3VfS7AN+HQGy4Cx/3OAbNRlUJFb/loNSEPk2M3QJe0UAW/JHMDUYB8B3iu0/hBgAHN1kAb0MavIAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table","description":"The input table to aggregate."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table with aggregation columns","description":"Result table with the aggregation columns per row."}],"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":"Aggregation Columns","description":"Select one or more columns to aggregate.","optional":false},{"name":"Aggregations","description":"Choose one or more aggregations to be applied to the selected aggregation columns. Only aggregation methods that are compatible with those selected columns are available. You can add the same method multiple times. However you have to change the name of the result column.\n<ul><li><b>Aggregation method</b> : Choose an aggregation method to be applied to the selected aggregation columns. Only methods compatible with those selected columns are available.</li><li><b>Column name</b> : Name of the resulting aggregation column. By default, the name suggested by the selected aggregation method is set.</li><li><b>Missing values</b> : Missing values are considered during aggregation if the missing option set to &#34;Included&#34;. Some aggregation methods do not support the changing of the missing option such as &#34;Mean&#34;.</li></ul>","optional":false},{"name":"Remove aggregation columns","description":"If selected the columns used to aggregate are filtered from the output table.","optional":false},{"name":"Remove retained columns","description":"If selected the columns that are not aggregate are filtered from the output table.","optional":false},{"name":"Maximum unique values per group","description":"Defines the maximum number of unique values per group to avoid problems with memory overloading. All groups with more unique values are skipped during the calculation and a missing value is set in the corresponding column, and a warning is displayed.","optional":false},{"name":"Value delimiter","description":"The value delimiter used by aggregation methods such as concatenate.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:fd74d1b4-da47-4c58-86e7-4fdd8c45dce0","user":"lukass","date":"2022-12-19T13:26:59+00:00"}],"kudosCount":1,"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":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.09624724061810154},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.07637969094922738},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.07328918322295806},{"id":"*PHWv6FsABEjrSc76","factoryName":"org.knime.base.node.preproc.rename.RenameNodeFactory","probability":0.05783664459161148},{"id":"*wiIVn14C9BeYBHqr","factoryName":"org.knime.base.node.preproc.columnaggregator.ColumnAggregatorNodeFactory","probability":0.05474613686534217},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.04988962472406181},{"id":"*2fI5rIsFDCFPHc0R","factoryName":"org.knime.ext.jep.JEPNodeFactory","probability":0.039293598233995586},{"id":"*aItro4n6xSMUuxg-","factoryName":"org.knime.base.node.preproc.ungroup.UngroupNodeFactory","probability":0.02781456953642384},{"id":"*zpGPAjDyExkFL2HB","factoryName":"org.knime.base.node.rules.engine.RuleEngineNodeFactory","probability":0.02384105960264901},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.02384105960264901}]}