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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive