Grouping by column headers

[cstafford]

I am creating a report based on output from another Alteryx Workflow. This output has several Brand names, however, I want to single out 4 Brands and group the remaining into a field called "OTHERS". What is the best way to perform this?

[Thableaus]

Hi @cstafford 

Could you please post a sample of your data so we could see what it looks like? There are several ways to do this.

Cheers,

[cstafford]

Here is an example:

I ended up using an if/then statement, but is their a tool within Alteryx that will do this? I tried the make group tool and that did not work.

[Thableaus · Accepted solution]

@cstafford 

In this simple example you could create a Vlookup table and use Find and Replace Tool.

It's easier to mantain and safer to avoid mistakes.

Cheers,

[Xandro]

SEE ATTACHED ALTERNATIVE METHOD.