Hello, I have an input data as folow: A1B3 B 5 A2C1B3A2A1B2C3 I want to summorize it as follow: A6B13C4 How do I do this in Alteryx? Regards, Tony

data summarize

Hello,

I have an input data as folow:

I want to summorize it as follow:

How do I do this in Alteryx?

Regards,

Tony

Preparation

This is what you have been looking for?

Hey @TonyMu like the name suggests, the Summarize tool can do this for you. Set it up as below (grouping by the ABC, and summing the numbers)

Hope that helps, Ollie

Great, thanks for your very fast reply 🙂

Is there anyway for summerizing as bellow as well?

from this:

to this:

A	1	2	4
B	1	2	3

thanks in advance,

Tony

Thank you for marking my post as a solution.

I am happy that I could help you!