I want to use the option sum under the GroupBy node when I select the manual aggregation tab but I cant find it. ANy help on this
Hi @radjapong
Welcome to KNIME Forum. Did you check the format of the column you want sum. It must be an Integer, Number or Double?
gr. Hans
4 Likes
Its almost certain that @HansS identified the problem. Depending on the type of data file you’re importing you may be able to use the transformations tab to change the columns you want to sum to a numeric format. The other alternative if the columns are string format is to use the String to Number node to convert the desired columns after importing the data.
4 Likes