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?
Solved! Go to 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!
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.