I would like to create a column segmenting the contents of another column into one of two classes.

gbennett

I would like to create a column segmenting the contents of another column into one of two classes.  The column contents either begins with "o" or "w". What would be the best approach to create another column classifying the "o" as "site one" "w" as "site two"?

 

Thanks

RGranada

Hi,

 

Try the following Beast Mode:

 

CASE WHEN LEFT(your_original_Column,1)='o' THEN 'site one'

          WHEN LEFT(your_original_Column,1)='w' THEN 'site two'

END

 

If you need more info on beast modes, this link can help :

https://knowledge.domo.com/?cid=beastmodecalculation

 

Hope this helps.

gbennett

This worked perfectly.  Thanks.