First Word Grouping

Mirnes · 2023-01-10T20:27:37+00:00

There was an error rendering this rich post.

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!

Find more posts tagged with

You can use the SPLIT_PART function.

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

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

@GrantSmith thanks for that! It worked.