Split a single column into multiple rows based on a delimiter
I have a column with a variable number of items, delimited by a comma.
For example: column_a: 1,2,3,4
Number of elements is variable - it can be a single element, or 50 (while I can set an upper limit, it can be dozens).
I need a way to split the data in the column into rows, so with the above example I'd like to have:
Input: column_a: 1,2,3,4
With Magic ETL I'm not able to do that, nor with SQL (again, without creating a very large and ugly SQL query to span maximum 50 elements).
Is there any other way other than scripting it externally to Domo? I have this requirement for several datasets and it starts to become an issue.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board