Math Formula sum() vs Column Aggregator node

Although I cannot find documentation for it, I have found that sum(col1, col2, col3…) works in the Math Formula node to give me the sum on multiple columns instead of using something like (col1 + col2 + col3).

It seems like this is the same as using the Column Aggregator node with these same columns and specifying Sum as the Aggregation function on the Options tab.

What are the differences or tradeoffs?
Are there other helpful undocumented functions in the Math Formula node?

Hi @BruceJohnson ,

I am probably not the right person to reply, but I saw you haven’t received answers for 20 hours so I thought I could help.

There is no difference in these two alternatives from a result point of view. However, I’d say that using a column aggregator node is better, because you can better see which columns have been selected for the aggregation instead of reading the formula inside the math formula node.

Plus, you can select columns by type (ex sum all doubles) or regex/wildcard (very handy!).

Hope this message has helped.

RB

4 Likes

Thanks for your reply.

1 Like