The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Value Counter

This node counts the number of occurrences of all values in a selected column.

Dialog Options

Column
The column whose values should be counted
Enable hiliting
If want to enable hiliting between the distinct values in the output table and the corresponding rows in the input table, check this box. But be aware that this may require a lot of memory if the table is huge.

Ports

Input Ports
0 Any datatable
Output Ports
0 One-column table with the different values as row keys and their occurrences as the only column.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.