topic Re: Creating New Field Values from Common Attributes in ArcGIS Pro Questions

Creating New Field Values from Common Attributes

AnnaWilson — Thu, 30 Nov 2023 22:21:04 GMT

So I have a table with an ID field, month field, year field and an injection amount field. The table comes from 2016, so the year field is populated with 2016. The ID field is duplicated 12 times to fit the 1-12 month field.

I am trying to create new fields like 1/16, 2/16, 3/16 and so on (there will be more years, but I'm just trying to do it with one now) with the injection amount values that were originally its own fields, populating the new fields.

Here's a picture to try to explain more

There are several thousand values so I don't want to have to do it manually. If there is a geoprocessing tool that might help me out, I would much appreciate it.

Thanks!

Re: Creating New Field Values from Common Attributes

DanPatterson — Thu, 30 Nov 2023 23:00:21 GMT

Summary Statistics (Analysis)—ArcGIS Pro | Documentation

with the case field as ID year and month

might work

Re: Creating New Field Values from Common Attributes

DuncanHornby — Fri, 01 Dec 2023 14:33:13 GMT

I would suggest you explore the Pivot Table tool then do a row sum to get that final field.

Re: Creating New Field Values from Common Attributes

AnnaWilson — Sat, 02 Dec 2023 23:29:32 GMT

This worked. Thank you so much!