Rounding Decimals in ETL, not in Beast Mode
Comments
-
I do not see an option for rounding in a magic ETL but you can use the round() function in a MySQL dataflow. An example of how to use the function is below. You can copy and paste this into a transform in a MySQL ETL to see how it works. You would replace the 25.751 value with the column name that you want to round.
select 25.751 as my_value
, round(25.751) as whole_number
, round(25.751,1) as 1_decimal_place
, round(25.751,2) as 2_decimal_place
-----------------
Chris0 -
Hi cwolman,
I appreciate your help.
As my situation, it's so great if we can rounding decimals in ETL, but we should make a try when the ETL finish and use MySQL ETL to rounding decimals.
Thank you.
0 -
@user10714 I found your post today while searching how to do the same thing myself.
I found a solution! You can use a set column type tile and change the decimal to a whole number. That rounds to the nearest whole number.
I also thought about converting the decimal to text and then breaking it apart with string operations, then combining back together, and then converting back to decimal.
Hope this helps you, or the next person to search this topic!
2
Categories
- 7.7K All Categories
- 12 Connect
- 925 Connectors
- 247 Workbench
- 441 Transform
- 1.7K Magic ETL
- 61 SQL DataFlows
- 456 Datasets
- 88 Visualize
- 222 Beast Mode
- 2.1K Charting
- 8 Variables
- 5 Automate
- 349 APIs & Domo Developer
- 85 Apps
- Workflows
- 17 Predict
- 3 Jupyter Workspaces
- 14 R & Python Tiles
- 242 Distribute
- 60 Domo Everywhere
- 241 Scheduled Reports
- 18 Manage
- 39 Governance & Security
- 46 Product Ideas
- 1.1K Ideas Exchange
- 6 Community Forums
- 19 Getting Started
- 6 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 577 日本支部