Add a count of record ids on each record

Question

Hello, below is my input data.

RecordIDCampaignDivisionStatus101APublic FundingHomeless ServicesFunded102APublic FundingHomeless ServicesFunded102APublic FundingHomeless ServicesFunded103APublic FundingHomeless ServicesFunded103APublic FundingHomeless ServicesFunded103APublic FundingHomeless ServicesFunded103APublic FundingHomeless ServicesFunded104APublic FundingHomeless ServicesPending105Public FundingHomeless ServicesFunded

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

103A   4

104A   1

105A   1

Thank you for taking a look!!

Paul

nakamott · Accepted Answer

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

DiganP · Accepted Answer

@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 🙂

JosephSerpis · Accepted Answer

Hi @paulb1 I mocked up a workflow that creates your output.