topic Re: limit float to 2 places in tmap in Talend Studio

limit float to 2 places in tmap

talendstar — Fri, 14 Jun 2019 21:24:30 GMT

I am using tmap to read data from a file and load it into a table.

One of the columns in the text file contains values like:

0.05

0.03

etc...

However when Talend flow uploads the data into the table the values change from 0.05 to 0.05000000075

or from 0.03 to 0.03999999911.

I have tried two approached in the tmap to try to reduce the value to two decimal places so I get only values like 0.05 or 0.03:

(row6.MinIncrease == null || row6.MinIncrease.equals("")) ? 0f :
row6.MinIncrease.floatValue()

(row6.MinIncrease == null || row6.MinIncrease.equals("")) ? 0f :
Math.round(row6.MinIncrease*100)/100f

but no luck. still getting values like 0.05000000075 .

What can I do here so I get only two decimal places?

thanks

Re: limit float to 2 places in tmap

Anonymous — Fri, 14 Jun 2019 21:53:13 GMT

Hi,

Did you try to add the precision part of your float column to 2?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: limit float to 2 places in tmap

talendstar — Tue, 18 Jun 2019 16:21:11 GMT

Hello Nikhil,

I set the precision to 2 for the float data type. But that is not working for me. I am still seeing the same values.

Is there anything else I can do?

Thanks

Re: limit float to 2 places in tmap

Anonymous — Tue, 18 Jun 2019 16:24:15 GMT

Hi,

Did you change the precision right from the schema of the input file or in between only from tMap?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: limit float to 2 places in tmap

talendstar — Tue, 18 Jun 2019 16:32:37 GMT

Please have a look at the attached screenshots:

Here is the schema for text file:

Here is the tmap:

One thing that I am doing in the tmap for this column is:

(row6.val == null || row6.val.equals("")) ? 0f :
Math.round(row6.val*100)/100f

thanks

Re: limit float to 2 places in tmap

talendstar — Tue, 18 Jun 2019 16:41:01 GMT

I tried it on another float column and still no luck.

Re: limit float to 2 places in tmap

Anonymous — Tue, 18 Jun 2019 16:50:12 GMT

Hi,

I am getting the data correctly for sample file.

I tired to pass directly and also tried the function provided by you. But I did not get any issue.

Personally, I would only go by null check for a float column like below and do not go for equal comparison with empty string.

Relational.ISNULL(row1.data)?0:row1.data

But if you are still having issue, I might be missing something trivial here. Lets check with our Guru @rhall

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: limit float to 2 places in tmap

Anonymous — Tue, 18 Jun 2019 18:24:31 GMT

Can you remove your database component and simply print out your number value to the output window? Also, what database are you using? This looks like a floating point error. If it occurs during your Talend job (which you should see by outputting the value to the output window), the best way of dealing with this would be to use a BigDecimal instead of a float.

Re: limit float to 2 places in tmap

talendstar — Wed, 19 Jun 2019 15:45:12 GMT

I am writing to Snowflake database.

Interestingly the source data file contains right value. For example:

0.05

But when written to Snowflake I get this:

0.05000000075

I will go ahead and try to use BigDecimal (I have not seen this working with Snowflake though).

Re: limit float to 2 places in tmap

Anonymous — Wed, 19 Jun 2019 15:59:37 GMT

Set the precision to 12 and just print to the output window. We need to know if this is a floating point issue caused during the processing of the number by Talend or after it is sent to Snowflake.

Re: limit float to 2 places in tmap

talendstar — Wed, 19 Jun 2019 16:49:03 GMT

I have turned on log4j and it prints each row of the data with correct values. Have a look at the last field below:

2D072|753|2536.1667|0.0|

06052|401|1801.1893|0.05|

Re: limit float to 2 places in tmap

talendstar — Wed, 19 Jun 2019 16:51:33 GMT

Also tried using BigDecimal. I could get the flow to execute with BigDecimal data type.

Re: limit float to 2 places in tmap

talendstar — Wed, 19 Jun 2019 17:01:14 GMT

I have got it to work. I modified the data type in the tmap to Double for both source and destination. Even though the column data type in Snowflake is float.

Appreciate your help and support.

Thanks

Re: limit float to 2 places in tmap

RahulKumar2 — Fri, 28 May 2021 10:52:14 GMT

it will not work, even if you change at schema level