Delimiter to split the column data into multiple columns
I would like request DOMO technical team to provide an Delimiter option in order to split the column data into multiple columns. A predefined function wherein we provide the delimiters which may be of different like '_' or "-" or "&" or " " etc. Giving the user an option to enter the multiple delimiters as per their data availability will provide an scope to split the column into multiples as per the conveince of the user.
Example : -
1. Area Sales Manager - Australia - Talent Pool
2. Brand Manager - New Zealand - Talent Pool (1)
3. Marketing Analyst - Malaysia - Talent Community and so on....
Comments
-
@SaiKumar this is a great request. Just to point out that when connecting to the data you have the ability to specify the delimiter for the file parsing.
In your case the data is "sub-delimited" inside one of those columns. This can be parsed in SQL but is not a simple process.
Will you submit this idea to the Ideas Exchange in Dojo??
Former Domo employee you can find me in the Dojo Community here @n8isjack1 -
@n8isjack-ret- Thank you for reverting to the query.
Yes, I do agree through SQL we will able to achieve the required data but as mentioned it is a tedeous process.
I have submitted it in the Idea Exchange in DOJO as suggested. As the character length is undefined the process of writing query is not an easy task.
It would be great if the Idea gets materialized.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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