Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Add a count of record ids on each record

paulb1
8 - 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

4 REPLIES 4
paulb1
8 - Asteroid

For clarity:  That 105 should be a 105A.

nakamott
8 - 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

DiganP
Alteryx Alumni (Retired)

@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
JosephSerpis
17 - Castor
17 - Castor

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

 

Count.PNG

Labels