What I'm searching for is a tool that will sum a field by a secondary unique field AND booleans...
Let's say I have 12 table each with 4mil records and the following fields:
- Donation_Amount ($ amount of a donation)
- County_FIPS (county from which the donation was made)
- Republican (y/n)
- Democrat (y/n)
- Independent (y/n)
- In_district (y/n)
- Individual (y/n)
- PAC (y/n)
I want to summarize donations per boolean for each unqiue county fips.
Ideally the result I'd like is a table of all unique FIPS and an amount sum and count for Repub, Dem, Ind, In_District, Indiv, PAC.
Tried to get it to work with iterate in model builder and couldnt... Also read about summarize and frequency tools but Summarize seems to be limited with how many secondary fields you can use, and Frequency tool is only for ArcInfo (I need for ArcView 10.1)
Essentially I know this is simply a database process to summarize data based on secondary fields... I have heard of tools in R that do this (in Plyr and Reshape2: cast/melt) but would ideally like to do it in a program with GUI and even more ideally, in ArcMap so it wouldnt require too much shuffling of data...
Thanks all! Much appreciated.