First Word Grouping

I've been having trouble getting Domo to group by the first word. Is this possible or would a Beast Mode Segment be necessary?


Example:

System | Application | Client | Problem


I am open to using Magic ETL or a Beast Mode segment if someone has an idea!


Thanks!

Comments

  • GrantSmith
    GrantSmith Indiana 🥷

    You can use the SPLIT_PART function.

    SPLIT_PART(`Name`, ' | ', 1)
    

    This will get the first value in your string split by the ' | ' delimiter.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**