Adding multiple columns into new column

[hloebel]

Seems like this should be relatively straightforward, but I have been really struggling with this. I am looking to add across multiple columns (columns E, F, and G in the attachment) with the total going into a new column. Thoughts on this?

[PeterA1 · Accepted solution]

Hi @hloebel 

That should just be a simple formula tool. I will confirm on my end but try just using a Formula Tool-->Add Column (Name it)-->Type [Field1]+...[Field N] and you should be golden. 

PS the Formula tool defaults data type to VString so you may want to change to numeric.

Attached is a workflow example. Just map the input data tool to the file on your computer and should be good to go. Hope I understood your goal correctly. 

Let me know if any issues!

[hloebel]

You did answer it. I knew it should be straightforward... the part that I was missing was naming the new column in the formula tool. Without the name, the formula was not working and I was just banging my head.