question Re: removing scientific notation after divison in Support Questions

removing scientific notation after divison

kumsath — Thu, 10 Mar 2022 08:57:59 GMT

I am using the below NIFI EXPRESSION in the update attribute

This works fine, but after division getting scientific notation, say for an example if the

GROSSDEPTH = 0.010000, then

the expression output is coming as :

GROSSDEPTH

1.0E-4

how to remove this scientific notation. Please help

Re: removing scientific notation after divison

steven-matison — Thu, 10 Mar 2022 18:47:55 GMT

@kumsath This may not be the best way, but check out this solution here:

https://community.cloudera.com/t5/Support-Questions/How-correct-convert-from-Decimal-with-E-to-float-in-Apache/m-p/236511

Re: removing scientific notation after divison

kumsath — Fri, 11 Mar 2022 00:01:10 GMT

Thanks for the update Steven. I had gone through those article before. Here I am using and update attribute which contains number for variables.

update attribute with multiple attributes

After this flow i am receiving the output as GROSSDEPTH =1.0E-4

So the question is execute script will work in this scenario? Please suggest.

Re: removing scientific notation after divison

steven-matison — Fri, 11 Mar 2022 13:24:15 GMT

@kumsath Yes, when i saw your post I started digging around too. The issue here is number manipulation and type casting a "number" versus a "string". That easy gets complicated in attributes and with nifi expression language functions. The solution i referenced would take the "number" and make a number in which the visual representation should then be correct. Its worth a try since that execute script should be very easy to test. The alternative is to do your "math" upstream or in an execute script processor not in updateattribute.