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

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

Find more posts tagged with

Accepted answers

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.

All comments

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.

This worked perfectly. Thanks.

Quick Links