GroupBy: Automatic Selection for Multiple Columns

[MaryseVB_BGIS]

Hi,

I’m aggregating a detailed report using the GroupBy node. I have to sum more than a hundred individual columns. Is there a way to sum them without having to change the Aggregation type to Sum for each and every one?

Can we change the Aggregation default value of the GroupBy node to Sum instead of Mean?

I’m not a programmer thank you for your support.

Summary

[eamendola]

Hi there @MaryseVB_BGIS
You could do this:

After you add all the desired columns, right click anywhere inside the configuration and then “Select all numerical columns”

After that, right click again and under Numerical Methods click on Sum. That would automatically change all columns to sum operation.

Hope it helps.

Cheers.

[badger101]

Thanks for this thread.

I changed the title of your post so that others looking for answers in the future can find this easily.

[eamendola]

Thanks @badger101 that is actually better.