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

gbennett
gbennett
in Magic ETL

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

Best Answer

  • RGranada
    RGranada Contributor
    Answer ✓

    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.

    Ricardo Granada 

    [email protected]

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.

Answers

  • RGranada
    RGranada Contributor
    Answer ✓

    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.

    Ricardo Granada 

    [email protected]

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • gbennett
    gbennett

    This worked perfectly.  Thanks.  

Categories