I'm working on ETL right now, I want to rounding a column which is in decimal. Our a goal is create a new Data Flow from few files, then from that Data Flow make some cards.
So, is there any help us to rounding in ETL Transform ?
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
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.