Create new column grouping data from previous column

ArminL

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

danrh

You could also use a Text Input with a Join.  It creates a nice list where you simple enter what genre drops into what group.

solution.yxmd