Best Of
Re: How do I take a portion of a column value and push it to a new column?
CASE WHEN REGEXP_LIKE(`field`, '^(A\d+).*$') THEN REGEXP_REPLACE(`field`, '^(A\d+).*$', '$1') ELSE 'unassigned' END
You can use a formula tile and a regular expression to pull out the values which start with A followed by some numbers.
^ - Start of the line
() - Match group to store the results found - in this case the first match group which is stored in the variable $1
A - the literal letter A
\d+ - One or more digits
.* 0 or more of anything
$ - The end of the string
Re: How do I take a portion of a column value and push it to a new column?
This would create a new field with the extracted value if it matches the logic, otherwise it's got a value of Unassigned.
`field` needs to be replaced with the source field / column which has your campaign name data.
Earn a badge and 20 easy points by updating locations in your profile!
We've recently added new location fields to your profile (Country and Geolocation) so we can make sure to let you know when Domo events are happening near you.
Earn an exclusive Location badge (and 20 quick points 😎) by updating the Country and Geolocation fields in your profile here.
** After you've updated those fields, comment on this post "DONE" to be given your badge.
Re: Variable Control Title and Descriptions - Ability to Format Text
Yes, would love a way to give us the ability to provide custom styling for cards, fields, etc.
