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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive