Multi-Field Sum

Hello,

I'm currently working on a workflow where i need to sum a column based off an ID. I know that i can use the summarize tool to accomplish this, however, i have nearly 300 columns in the data set that i need to do this too and i don't want to create 300 summarize tools in my workflow to accomplish this. Does anyone know how to perform a multi-field summary? I've use the Multi-Field tool before, but i don't see a calculation option for sum.

Developer

Developer Tools

Preparation

Accepted answers

binu_acs

@cpetten1 Transpose your columns and take the sum using summaries tool. In summarise tool group by ID, Name , Sum Value, then cross tab the result

All comments

binu_acs

@cpetten1 Transpose your columns and take the sum using summaries tool. In summarise tool group by ID, Name , Sum Value, then cross tab the result

SPetrie

My first though would be a transpose and cross-tab with a sum option.

Can you share some example data and how its setup? It will be easier to assist if we can see how it looks going in and an example of what you want the output to be.

cpetten1

Thanks everyone. very simple solution, just didnt think about cross tabbing the results back to the original format. Works perfectly!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703