Hello friends,
What is the best way to sum values from multiple columns, from an Excel file, into a new column? If it is an expression, could you please show an example?
Thank you!
I would use the Formula tool. Place it after your Input Data tool, then from the drop-down in the Formula tool's configuration select "+ Add Column" and type the name for your new column. For the expression, use a formula to add them together:
Make sure to choose an appropriate Data type (i.e. Int16/32/64, Float, Double, etc) so you can use it later in your flow.
Hope this helps!
Dan
I also have a similar question...I currently have 10+ columns that I would like to sum up. Is there a way to do it without having to manually put in each field name into the formula tool?
Thank you so much. I was struggling to solve this since yesterday.
