# Aggregate Data

**URL:** <https://forum.knime.com/t/aggregate-data/100>\
**Category:** KNIME Analytics Platform\
**Created:** [April 2, 2007, 5:15pm UTC](https://forum.knime.com/t/aggregate-data/100 "2007-04-02T17:15:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![logit](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/edb3f5/32.png) [@logit](https://forum.knime.com/u/logit)\
**Post date:** [April 2, 2007, 5:15pm UTC](https://forum.knime.com/t/aggregate-data/100/1 "2007-04-02T17:15:49Z")

</div>

Hi all,

I try to aggregate data. I need to sum und average variables by a variable .

Does anybody have a hint how to aggregate data.

Do I have to use the java snippet? The R-Interface does not handle large data sets.

Any help is highly appretiated

J

---

<div class="post-metadata">

**Author:** ![unknown\_user](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/u/ac91a4/32.png) [@unknown\_user](https://forum.knime.com/u/unknown_user)\
**Post date:** [April 3, 2007, 1:17pm UTC](https://forum.knime.com/t/aggregate-data/100/2 "2007-04-03T13:17:58Z")

</div>

Hi,

what do you mean by 'aggregate'? Do you want to aggregate row or column wise? Can you elaborate a bit more on what you intend to do?

The Java-Snippet node can only help when you aggregate row-wise, for instance if you want to append a new column to the table containing the sum of the i-th and j-th cell of a each row.

Column-wise aggregation is not as easy. Have you had a look at the Jython nodes [http://www.knime.org/download\_extensions.html#python](https://forum.knime.com/download_extensions.html#python)? They should allow you to apply much more complex transformation. Not that I have used them often but they are definitely powerful (thanks to Tripos for contributing them).

Cheers,  
 Bernd

---

<div class="post-metadata">

**Author:** ![unknown\_user](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/u/ac91a4/32.png) [@unknown\_user](https://forum.knime.com/u/unknown_user)\
**Post date:** [April 3, 2007, 1:44pm UTC](https://forum.knime.com/t/aggregate-data/100/3 "2007-04-03T13:44:57Z")

</div>

Hi,

there is the "Statistics View" node (category "Statistics" in the node repository), that computes the Min, Max, Mean, Std. Deviation and Variance for each column/attribute. It doesn't show the sum of all values in one column though, if that is what you needed.

Regards,  
 - Peter.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:14pm UTC](https://forum.knime.com/t/aggregate-data/100/4 "2023-06-23T20:14:05Z")

</div>