How to add a column which counts duplicates record ?

Hello, I am a beginner, and I've tried to find via the discussions the solution of my problem. Unfortunately I haven't...so hopefully you will be able to help me out with this : I have a table below; I need to count how many duplicates I have in the column ID NUMBER; and put the result in a new column COUNT. So then, I can calculate the real amount by doing as follow = Amount/Count. In Excel, the formula is COUNTIF Which tool can I use ? Thanks in advance for your input, CDON

Alteryx_CountDuplicates.PNG

Transformation

Accepted answers

bpatel

Hi @CDON ,

you can use the summarize tool to count number of duplicates and the join tool to add it back to your original data set. i attached a workflow as an example. i hope this helps!

count duplicates.yxmd

All comments

GiuseppeC

Hi @CDON,

try the Summarize tool. Select Client ID and then add a Group By action and a Count action. This will give you a table with 2 columns, Client ID and Count, which you can Join back to your original table, but Client ID to append the Count to your original table.

Hope it makes sense. It should be pretty straightforward once you've understood how the Summarize tool work (click on the tool > Open Example to see how to use it).

Would also recommend the Alteryx for Excel users interactive lessons in the Academy section.

Hope this helps!

Giuseppe

bpatel

Hi @CDON ,

you can use the summarize tool to count number of duplicates and the join tool to add it back to your original data set. i attached a workflow as an example. i hope this helps!

count duplicates.yxmd

CDON

Thanks a lot. It did work !! What a wonderful tool and great Community !!

CDON

Thank you Giusseppe, with the attached I received from someone I could make it.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280