Reformating data in a feature class/table

2921
5
Jump to solution
12-16-2015 10:03 AM
benberman
Occasional Contributor

I received a feature class that is currently in the format, illustrated below..

AREAPOPUNDER20POPOVER20POPOVER50
TAMPA1000
TAMPA2000
MIAMI500
MIAMI1000
MIAMI3000
MONTREAL4000
MONTREAL5000

I would be needing to re-format this feature class to:

AREAPOPUNDER20POPOVER20POPOVER50
TAMPA10002000
MIAMI50010003000
MONTREAL40005000

If anyone could recommened a script or a tool that would help reformat, that would be really helpful

thanks in advance.

0 Kudos
1 Solution

Accepted Solutions
DarrenWiens2
MVP Honored Contributor

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.)

View solution in original post

5 Replies
WesMiller
Regular Contributor III
0 Kudos
DarrenWiens2
MVP Honored Contributor

Summary Statistics, using AREA as case field and the other fields as statistics fields should do the trick.

0 Kudos
benberman
Occasional Contributor

Does not work. What statistic type would you assign to the other fields, anyway?

0 Kudos
DarrenWiens2
MVP Honored Contributor

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.)

benberman
Occasional Contributor

Darren, changing the type to MAX does work. Thank you so much.

0 Kudos