I received a feature class that is currently in the format, illustrated below..
AREA | POPUNDER20 | POPOVER20 | POPOVER50 |
---|---|---|---|
TAMPA | 1000 | ||
TAMPA | 2000 | ||
MIAMI | 500 | ||
MIAMI | 1000 | ||
MIAMI | 3000 | ||
MONTREAL | 4000 | ||
MONTREAL | 5000 |
I would be needing to re-format this feature class to:
AREA | POPUNDER20 | POPOVER20 | POPOVER50 |
---|---|---|---|
TAMPA | 1000 | 2000 | |
MIAMI | 500 | 1000 | 3000 |
MONTREAL | 4000 | 5000 |
If anyone could recommened a script or a tool that would help reformat, that would be really helpful
thanks in advance.
Solved! Go to Solution.
Hmmm... it works for me. Use MAX as the statistic type for each of the pop fields and AREA (the city names) for the case field. MAX should work regardless of whether it's a text or numerical field.
If that doesn't work, how does it not work? Error, blank output, wrong output?
1.)
2.)
3.)
You could use Summarizing data in a table—Help | ArcGIS for Desktop
Summary Statistics, using AREA as case field and the other fields as statistics fields should do the trick.
Does not work. What statistic type would you assign to the other fields, anyway?
Hmmm... it works for me. Use MAX as the statistic type for each of the pop fields and AREA (the city names) for the case field. MAX should work regardless of whether it's a text or numerical field.
If that doesn't work, how does it not work? Error, blank output, wrong output?
1.)
2.)
3.)
Darren, changing the type to MAX does work. Thank you so much.