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?
Solved! Go to Solution.
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,
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.
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,