How to create a beast mode for 1st initial of first name and add the last name

Abe
Member
in Beast Mode
Hi everyone,
I'm having issues trying to get a beast mode to work when trying to get the 1st letter of the first name and adding it to the last name.
This is what I have - SUBSTRING('Ticket_Owner_First_Name',1) + 'Ticket_Owner_Last_Name'
I've tried different variations of this but can't seem to get it correct.
Any assistance is greatly appreciated.
Thank you
Tagged:
0
Best Answer
-
Try this:
CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
Try this:
CONCAT(LEFT(TicketOwnderFirstName,1),TicketOwnerLastName)
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
Thank you sir for the assistance!
When testing different formulas I also tried concat but did not use the " Left" function inside the parenthesis.
Thank you again for the assistance.
1
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InWelcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InCategories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 21 AI Chat
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 414 Distribute
- 122 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive