GroupBy : "Group contains to many values"

Hello,

I often get the error "Group contains to many values", when I use the GroupBy node. It happens when the data are very large and when I use an aggregate method such as List or Count unique.

Where does this limitation come from, and can I modify something in the Knime settings to avoid it?

Thank you

Nicolas

2 Likes

Hi Nicolas,

the GroupBy-node has an option "Maximum unique value per group" in the "Options"-tab that should allow you to modify this setting. Of course, you might run into memory issues if you set that value too high.

Regards,

Nils

3 Likes

Hi Nils,

It was just in front of me...

Thank you,

Nicolas

Is there a way to change the default setting from 10,000 to more than 10,000?

Hi there,

sure it can be changed. On every tab under Advanced settings panel. See picture:

Br,
Ivan