GroupBy Node Missing 'SUM" Aggregation Channel

[WEnge]

I’m new to KNIME but I haven’t been able to find any information on this topic. When I go to the Manual Aggregation option of the GroupBy node, there is no option for SUM in the drop down. Am I missing something?

[morpheus]

Hi @WEnge,
did you checked the datatypes of your source? I assume there are no nummeric types in. Otherwise you should be able to sum data.
BR

[WEnge]

Thanks for the quick responses! I’m trying to do the Manual Aggregation on marketing impressions, all the numbers are numerical values. The only options in my drop down are:

Concatenate
Count
First
Last
List
List (sorted)
Maximum
Minimum
Missing Value Count
Mode
Percent
Set
Unique Concatenate
Unique Concatenate with count
Unique Count

[Daniel_Weikert]

And the column data type is numeric?
br

[bruno29a]

Hi @WEnge , and welcome to the Knime Community.

It most certainly has to do with the column type as @morpheus mentioned, and like @Daniel_Weikert is asking, what is the type of the column? Any Math operations such as SUM cannot be applied on String type columns for example, and Knime can pre-detect these situations and will not “offer” these options if the column type is not a numeric one.

You may need to convert the column to a numeric one if that’s the case.

You can use the Column Rename node to change the type, or use the Column Expression node to do so.

If the input is from a file, you can actually configure the column type at the Reader node itself.

[iCFO]

If you are having trouble finding the data types and converting them then just drop this node in front of GroupBy. It typically does a pretty good job.

Column Auto Type Cast

[WEnge]

Thank you all for your support, I greatly appreciate all the help. The Column Auto Type Cast did the trick so something was definitely off with something in the column, as you all suspected. Officially completed my first workflow! Thanks again!