Rounding Decimals in ETL, not in Beast Mode

Reply
Visitor

Rounding Decimals in ETL, not in Beast Mode

Hi there,

 

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 ?

 

Thanks.

Major Blue Belt

Re: Rounding Decimals in ETL, not in Beast Mode

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

Chris
Visitor

Re: Rounding Decimals in ETL, not in Beast Mode

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.

Announcements
Dojo Day is Coming! Mark your calendars for May 30th 0900-1700 MST Click here for more information