Concatenate unique and sum values

[MarcosC_]

Hello guys,

Still a beginner in Alteryx but I really can't seem to figure how to make this one work. Keep making a mess of this.

I need to concatenate each individual client and sum the values (but keep the zeros).

For example in screenshot shown attached, client B should show as total zero.

Either I get multiple records, or through the "SUM", the zero values are removed can just can't get it to work.

My workflow is already gigantic and this next step isn't helping :(

Thanks,

Marcos

[Qiu · Accepted solution]

@MarcosC_ 
Maybe I am missing something, but maybe A Summarize Tool?

[caltang]

@Qiu I have the same thoughts. A Summarize tool should do it. @MarcosC_ what is missing?

[MarcosC_]

Hi all,

You're missing the fact that I'm a jackass (facepalm). So sorry.

I was too absorbed with the macro thing that I got stuck stupidly here and was over complicating things unnecessarily and couldn't for the life of me figure it out....
Thanks for the help and I'm sorry to waste your time ahhaha.

[caltang]

Happens to the best of us. Don’t sweat it.