Crosstab Query

1259
3
06-22-2012 09:56 AM
Status: Closed
Labels (1)
ChrisRumig
New Contributor III
A tool that allows you to crosstab data for analysis would be useful.  In MS Access you can create crosstab queries which are useful for summarizing data over time based on a whole set of parameters.  Very often I find myself creating data or maintaining planning related datasets in personal geodatabases because I can easily create crosstab queries inside the Access backend.  However, this is impossible if the data is stored inside a file geodatabase because you can't access the backend data through MS Access.
3 Comments
DavidKnudsen
I may be wrong, but the "Pivot Table" tool in the Toolbox may accomplish the crosstab that you want, under a different name. Have you tried it?
DuncanHornby
It's worth emphasising that the Pivot Table tool is an ArcInfo licensed tool so of no use to us lesser mortals.
SSWoodward
Status changed to: Closed

This idea has been closed as a duplicate of the Data Management Idea linked below. Don't worry, you can still show your support by commenting and adding kudos to the open idea. Thanks for your contributions!

https://community.esri.com/t5/data-management-ideas/crosstab-query/idi-p/922384