Hello, below is my input data.
RecordID | Campaign | Division | Status |
101A | Public Funding | Homeless Services | Funded |
102A | Public Funding | Homeless Services | Funded |
102A | Public Funding | Homeless Services | Funded |
103A | Public Funding | Homeless Services | Funded |
103A | Public Funding | Homeless Services | Funded |
103A | Public Funding | Homeless Services | Funded |
103A | Public Funding | Homeless Services | Funded |
104A | Public Funding | Homeless Services | Pending |
105 | Public Funding | Homeless Services | Funded |
I would like to be able to count the each record id and write the count to a new column. Like so...
101A 1
102A 2
102A 2
103A 4
103A 4
103A 4
103A 4
104A 1
105A 1
Thank you for taking a look!!
Paul
Solved! Go to Solution.
For clarity: That 105 should be a 105A.
Hi @paulb1
You would use the summarize tool to group by and count on Record ID. That will give you the number of times a record ID appears. Then you can use the join tool or append fields tool to attach it on your original table
@paulb1 You want to use the summarize tool to get the count and then the join tool to join that count with the original dataset. Attached is the workflow 🙂