Merge common name

Question

Hi ,

I need a help to resolve below issue .

Problem  Nameamount1Diversifying3002Diversifying prospectus2003Diversifying strategies500

I want to merge below input with common name and get total amount

Desired output Diversifying1000

regards

Rojan

atcodedog05 · Answer

Hi @rojan

Here is dynamic solution using Fuzzy matching this should work for different common word changes.

Workflow:

Hope this helps : )

group and sum.yxmd

rojan · Answer

Hi,

Can you please show me the formula, I am getting error while I apply the way what you said

Regards

Rojan

anandshingi · Answer

I assume you may have another row that does not contain 'diversifying' and you want to avoid that.

1. use the formula tool and add new column with formula contains[Name] = ''diversifying''.

2. Use Summarize tool to sum data. group by newly added column.

Cheers