Magic ETL Calculator

mcoblentz
mcoblentz 🟡
in Ideas Exchange

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
Up
3 votes

· Last Updated

Comments

  • PEAKS_valleys
    PEAKS_valleys

    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!

  • mcoblentz
    mcoblentz 🟡

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

    Hi,

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

  • PEAKS_valleys
    PEAKS_valleys

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

This discussion has been closed.

Categories