Beast mode for help Sorting column
I need a beast mode so i can sort a column. I need to take the number out of this Engine column so then can sort in order. I have values like this
Engine 1
Engine 2
Plant Engine 1
Engine 3
Plant Engine 2
Engine 4
Engine 5
I figure if i can just do a formula to take out the number then i can sort them together based on number
Best Answers
-
There may be an easier way, but I usually write a beast mode to assign a number to each string value, like:
case when
engine
= 'Engine 1' then 1when
engine
= 'Engine 2' then 2when
engine
= 'Plant Engine 1' then 3….etc.This may not be ideal if the values of the string change or keep growing over time.
If the number is always the last character of the string, I think you can do right(`engine`, 1), but if the data is similar to your sample, you'll have two 1's, two 2's, etc.
0 -
If you have a lot of different combinations and don't want to do this manually, an option is to do it in ETL with REGEXP_REPLACE.
REGEXP_REPLACE(string, '^.(\d).$', '$1')*1
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1
Answers
-
There may be an easier way, but I usually write a beast mode to assign a number to each string value, like:
case when
engine
= 'Engine 1' then 1when
engine
= 'Engine 2' then 2when
engine
= 'Plant Engine 1' then 3….etc.This may not be ideal if the values of the string change or keep growing over time.
If the number is always the last character of the string, I think you can do right(`engine`, 1), but if the data is similar to your sample, you'll have two 1's, two 2's, etc.
0 -
If you have a lot of different combinations and don't want to do this manually, an option is to do it in ETL with REGEXP_REPLACE.
REGEXP_REPLACE(string, '^.(\d).$', '$1')*1
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive