Any way to normalize a column of data?
Hi everyone,
I'm working on a dataset that has an attribute structured with a list of sub-attributes and values, which are separated by colon or coma respectively like this:Does anyone know which tools in Domo can I use to flatten this?
I hope this could be like the following instead:
Comments
-
Hi, user06327,
You can probably accompish this in either SQL or ETL dataflows in Domo. You can think of the task one of two ways:
1) extract substrings for the various fields you want to capture. This can be done in a SQL dataflow. e.g. (pseudocode):
substring_index(`accelleration`,',',1) -- returns the string from the beginning to the first comma
2) replace all the text with an expty string except for the part you want to keep. Going this route, you can use the "Replace Text" block in ETL. You'll have the option of using regular expressions, too, though looking at your dataset, that probably won't be necessary.
In either case, you'll end up repeating essentially the same process for each of the various fields you want to extract.
Check out this Knowledge Base article, which should give you the details you'll need: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Pulling_a_Segment_of_Text_from_a_Text_String
Cheers
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive