Hi Community,
my problem is as follows:
I want to create a new column, which groups several strings from a previous column. I guess it works somehow with a nice IF... formula, but since I'm pretty new to alteryx i can't come up with the right one.
Genre | Genre Group |
R&B | Urban |
Hip/Hop | Urban |
Rap | Urban |
Hard-Rock | Rock |
Metal | Rock |
Soft-Rock | Rock |
See this table as an example. I simply want to create the new column "Genre Group" based on the column "Genre". I'm sure its really basic stuff, just want to take a short cut here with your help :)
Thanks in advance
Solved! Go to Solution.
I'd use a Formula tool and use the SWITCH function :
SWITCH([Genre],[Genre],
"R&B", "Urban",
"Hip/Hop","Urban",
"Rap","Urban",
"Hard-Rock","Rock",
"Metal","Rock",
"Soft-Rock","Rock"
)
You can easily add rows as you go :)