community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Add a count of record ids on each record

Asteroid

Hello, below is my input data. 

 

RecordIDCampaignDivisionStatus
101APublic FundingHomeless ServicesFunded
102APublic FundingHomeless ServicesFunded
102APublic FundingHomeless ServicesFunded
103APublic FundingHomeless ServicesFunded
103APublic FundingHomeless ServicesFunded
103APublic FundingHomeless ServicesFunded
103APublic FundingHomeless ServicesFunded
104APublic FundingHomeless ServicesPending
105Public 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

102A   2

103A   4

103A   4

103A   4

103A   4

104A   1

105A   1

 

Thank you for taking a look!!

 

Paul

Asteroid

For clarity:  That 105 should be a 105A.

Highlighted
Asteroid

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

Alteryx
Alteryx

@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

recordid.PNG

Digan
Alteryx
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Count.PNG

Labels