Creating New Field Values from Common Attributes

281
3
Jump to solution
11-30-2023 02:21 PM
AnnaWilson
New Contributor

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 

IMG_5767.jpg

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!

0 Kudos
1 Solution

Accepted Solutions
DuncanHornby
MVP Notable Contributor

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

View solution in original post

3 Replies
DanPatterson
MVP Esteemed Contributor

Summary Statistics (Analysis)—ArcGIS Pro | Documentation

with the case field as ID year and month

might work


... sort of retired...
0 Kudos
DuncanHornby
MVP Notable Contributor

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

AnnaWilson
New Contributor

This worked. Thank you so much!

0 Kudos