community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Grouping by column headers

Asteroid

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?

Alteryx Certified Partner
Alteryx Certified Partner

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,

Highlighted
Asteroid

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.

 

BRAND.PNG

Alteryx Certified Partner
Alteryx Certified Partner

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

 

 

1.PNG2.PNG

 

Cheers,

Meteoroid

SEE ATTACHED ALTERNATIVE METHOD.

Labels