Magic ETL Calculator

I have three columns to sum and the calculator only allows two.  it would be nice to be able to have more than just two columns to sum in a calculation.  

3
3 votes

· Last Updated

Comments

  • Hey @mcoblentz - Agreed that it would be nice to sum more than two fields at a time. This is a bit of a workaround, but if you take your input dataset, sum two fields, add in the select fields step, and then add another calculator step you can call the inital summed column and add in the third. You could then repeat this process to sum mulitple fields.

     

    Total_Actions.png

     

    Hope this helps!

  • 2016-07-12_13-20-57.png

    Hi,

    Yes, we figured that out.  Still, when adding fields together it seems a bit onerous...

  • Very cool and still agree that it would be great to sum more than two fields at a time. 

This discussion has been closed.