{"title":"Row Aggregator","nodeType":"Manipulator","id":"*NtiMv8IfKOQIOILD","factoryName":"org.knime.base.node.preproc.rowagg.RowAggregatorNodeFactory","factoryId":"org.knime.base.node.preproc.rowagg.RowAggregatorNodeFactory","path":["Manipulation","Row","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Aggregate columns using an aggregation function. The rows can optionally be grouped by a category column. Some aggregation functions support using a weight from a weight column.\n <br />\n If you need more sophisticated functionality, you can use the <a href=\"https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.groupby.GroupByNodeFactory\" rel=\"ugc nofollow noopener noreferrer\">GroupBy</a> node.</p>\n        ","shortDescription":"Aggregate columns.","keywords":["Group by"],"deprecated":false,"streamable":true,"tags":["Manipulation","Row","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAAAEKADAAQAAAABAAAAEAAAAAA0VXHyAAAA2klEQVQ4EZWTMQ7CMAxFKerAKSqOwFAGGLgGI0dpOAoj12CAAQaOgHoKNsi3+NGXhWnJEie1X/631WqzXr0mbp3Ol8pdhccaXxbtsiTcb1eL501j4Eff/4RNS6ULhgqZbgr4Ki//2UMLYyGhBQdI7lyOoyzkhna5JyhKfmqDFjgNgZSpoXehBRZyGnnfQwFk6AotsBDJvlinZoDZblugz8PRYlUg8hM+Mh+5oQUqIAiQXGsAQLhMAV/lpe4AASI2Os0PLThIaaD/0UILlP4BJQVqHFpgDzT5W/wG0QVpJhug6rwAAAAASUVORK5CYII=","sinceVersion":"5.0.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Table","description":"The table to aggregate."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Aggregation results","description":"The table containing aggregation results."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Grand-total results","description":"Contains the single-row table with &#34;grand total&#34; values if, and only if, the corresponding output setting is enabled and a category column is selected. Otherwise, the output is inactive."}],"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":"Category column","description":"Select the column that defines the category on which rows are grouped. If no category column is selected, &#34;grand total&#34; values in which all rows belong to the same group will be calculated.","optional":false},{"name":"Aggregation","description":"Select the aggregation function to be applied on all rows belonging to the same category.\n<ul><li><b>Occurrence count</b> : Count how many rows occur</li><li><b>Sum</b> : Sum up values, optionally weighted by the value from the weight column</li><li><b>Average</b> : Calculate the mean value, optionally weighted by the value from the weight column</li><li><b>Minimum</b> : Calculate the minimum value</li><li><b>Maximum</b> : Calculate the maximum value</li></ul>","optional":false},{"name":"Aggregation columns","description":"Select the columns to apply the aggregation function to.","optional":false},{"name":"Weight column","description":"Select the column that defines the weight with which a value is multiplied before aggregation. Note, that only the aggregation functions &#34;Sum&#34; and &#34;Average&#34; support a weight column","optional":false},{"name":"Additional \"grand totals\" at second output port","description":"If a category column is selected, additionally compute the aggregations <i>without</i> the category column (&#34;grand totals&#34;) and output them in the second output table. The second output is inactive if no category column is selected or this setting is not enabled.","optional":false},{"name":"Enable Hiliting","description":"Enable hiliting between the input port and the aggregated output table.","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":[]}