I received a feature class that is currently in the format, illustrated below.. AREAPOPUNDER20POPOVER20POPOVER50TAMPA1000TAMPA2000MIAMI500MIAMI1000MIAMI3000MONTREAL4000MONTREAL5000 I would be needing to re-format this feature class to: AREAPOPUNDER20POPOVER20POPOVER50TAMPA10002000MIAMI50010003000MONTREAL40005000 If anyone could recommened a script or a tool that would help reformat, that would be really helpful thanks in advance.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Reformating data in a feature class/table

benberman

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.

Trouver plus de publications taguées avec

Accepted answers

DarrenWiens2

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

All comments

benberman

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

DarrenWiens2

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

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

DarrenWiens2

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

WesMiller

You could use Summarizing data in a table—Help | ArcGIS for Desktop

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.