Adding values in a cell which are separated by commas

[murthybhs]

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!

[grazitti_sapna]

Hi @murthybhs , try this.

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

Thanks.

[atcodedog05 · Accepted solution]

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 😀👍

[Qiu · Accepted solution]

@murthybhs 
Is this what you want?

[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. 

[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.

[DeanWest]

You are most definitely correct! Thank you for pointing that out, I'll correct my solution now. 

[Qiu]

@atcodedog05 
I did not even notice the difference.😅

[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.