Counting occurrences and generating it in new column

Hi,

How can Knime count occurrences and generate the counting in a new column?

Originally, I have one column, as showed below:

Column 1

John (2006)

John (2006)

John (2006)

Smith (2013)

Smith (2013)

 

I would like as a Knime output the following:

Column 1            Column 2

John (2006)        3

Smith (2013)      2

 

Many thanks in advance,

Cadu

Hi Cadu,

The GroupBy node is useful in this regard. Select the column for grouping and the count function for the aggregation, though you might need to add a new column before.

Hope this helps, gabor