topic Re: Merge common name in Alteryx Designer Desktop Discussions

Merge common name

rojan — Thu, 13 Jun 2024 22:08:45 GMT

Hi ,

I need a help to resolve below issue .

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

Desired output
Diversifying	1000

regards

Rojan

AbdulBasit — Sun, 22 Aug 2021 18:45:07 GMT

Use a Text to Column tools and select a space bar as a delimiter.

and if you find this helpful mark it as accepted solution

anandshingi — Mon, 23 Aug 2021 01:24:29 GMT

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

rojan — Mon, 23 Aug 2021 12:42:40 GMT

Hi,

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

Regards

Rojan

atcodedog05 — Mon, 23 Aug 2021 12:55:30 GMT

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

Workflow:

Hope this helps : )