Text to Columns for Multi-select Values
A lot of SaaS services (Salesforce, JIRA, etc...) store multi-select lists as semi-colon separated values within the same field. As the product currently stands DOMO does not give users a way to analyze this data beyond identical selections.
Example: "Selection 1; Selection 2" and" Selection 1" are seen as separate text values rather. This is not representative of the actual data where "Selection 1" has a count of 2 and "Selection 2" has a count of 1.
Allowing DOMO users to separate multi-select values into multiple columns would let us visualize and research the relationships between each multi-select value. As things currently stand any multi-select value is incompatible with DOMO.
Comments
-
I just ran into this myself. That in the Magic ETL there's no text to columns option. My plan for now is to create a calculated column using Beast Mode and use substring to make the split. Not ideal though.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 466 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有