grouping and renaming.

Question

Hello all:

I don't know the exact syntax or name of what I want to do, but I want to take a table like this...

GroupInOutA51B61C35D52E57

and convert it to a table like this...

GroupInOutA2416

in this case, I have a 25000 row dataset where the group (in my case this is Organization) has been identified in different ways (either as "Q.A." or "Quality" or "QA" or "Qual").  What I wish to do is to group them all and call it "QA" and have all their rows sum up.  I have seen this feature in Tableau, and was wondering how to do it in Alteryx to minimize my reliance on Tableau (primarily to speed up my Tableau visualizations).

Any thoughts?

-Tesh.

binu_acs · Accepted Answer

@prpatel One option is to add a column Group using formula tool and assign a variable ‘QA’

summarise tool group by the column Group and take sum of the other two columns

AngelosPachis · Accepted Answer

Hi @prpatel ,

Alteryx doesn't have a native way to group values like Tableau has. What you can do is either use a formula tool to just rename groups A, B, C, D and E to just A and then summarize your values

OR

since all values under the group column will have to become A (or in your case "QA") then you can first use a summarize tool to find the sum of Ins and Outs and the use a formula tool to create the [Group] column

Hope that helps,

Angelos