Sum similiar numbers in a column

Question

Hey everyone,

I have a question to the following use case:

I have this data and I would like to calculate the number of numbers that occur and output them to the right.

i actually thought that summarize tool may help, but i couldn't get it to work.

Can anyone help me with that?

DataNath · Accepted Answer

Hey @maxse, you were right with the Summarize. You just need to Group by [Numbers] and then perform a Count of [Numbers] as well. After that, you just join back to your starting data set based on [Numbers]:

JosephSerpis · Accepted Answer

Hi @maxse the summarise tool is needed but also a join tool is needed to tackle this challenge. So you join the results back onto your orginal data.

IraWatt · Accepted Answer

Hey @maxse,

Similar to the other responses but I added a multi row formula so that it would differentiate two groups with the same number separated from each other.

If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com