If Statement Set Analysis

[CJR]

Hi all, I'm trying to set up a dimension where if the field equals one of several values, then it = Category 1, if it equals another value, it is category 2, otherwise category 3. I've been trying the below but can't quite get it...any tips welcomed! Thanks!

if(match(Field1='A','B','C','D') ,'Category 1',
if(Field1={'E'},'Category 2',
'Other'
))

[Or]

That's the wrong syntax all around:

For match, the syntax is Match(Field1,'A','B','C','D') with no equal sign.

Set analysis can only be used with aggregation functions, which this lacks. It's also missing the open and close brackets {< >}.

[joaopaulo_delco]

Hi @CJR 

      I recommend you set up this on script in the Data Load editor. Creating a new dimension.

It would be a more elegant solution. Better performance and easier to implement.