Adding values in a cell which are separated by commas

Hello everyone,

I very much appreciate how the community was helpful in answering my questions. I have a dataset that looks as below.

I want to see if Alteryx would be able to add values separated by commas and give the sum in that cell.

For example,

company B for Apr-20, I want 900+1200 = 2100 (sum only) instead of 900,1200 and

company A for Jul-20, I want 2000+1000 = 3000 (sum only) instead of 2000,1000

At the end of the workflow, I want something that looks like this where all the values that got separated by a comma(,) added up and everything else stays intact:

Any help in this is much appreciated.

Thank you!

Accepted answers

atcodedog05

Hi @murthybhs

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

add.yxmd

Qiu

@murthybhs
Is this what you want?

1026-murthybhs-A.yxmd

All comments

grazitti_sapna

Hi @murthybhs , try this.

If this is what you are looking for kindly mark this post as solution.

Thanks.

Adding values Comma Separated-GS.yxmd

atcodedog05

Hi @murthybhs

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

add.yxmd

Qiu

@murthybhs
Is this what you want?

1026-murthybhs-A.yxmd

DeanWest

Here is my corrected solution. A Dynamic Replace Tool is in fact required because of the special character in the Field Names. I used a Select Tool to change the datatype instead of a toNumber() function.

Parse-Sum_solution-DeanWest.yxmd

atcodedog05

Hi @DeanWest

We are using Dynamic rename to change "Apr_20" to "Apr-20" to match the format.

Our output is similar to yours before that tool.

atcodedog05

Happy to help 🙂 @murthybhs

Cheers and Happy Analyzing 😀

grazitti_sapna

Not sure what I did wrong maybe it is the comma separators that I used. Here is the updated workflow.

Adding values Comma Separated-GS.yxmd

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157