First Word Grouping

Mirnes
Mirnes Member
edited March 2023 in Beast Mode

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 Coach

    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!**
  • Mirnes
    Mirnes Member

    @GrantSmith thanks for that! It worked.

Categories