Support Questions

Find answers, ask questions, and share your expertise

removing scientific notation after divison

avatar
Contributor

I am using the below NIFI EXPRESSION in the update attribute

GrossProducFormula.PNG

 

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 helpGrossProductDepthValue.PNG
3 REPLIES 3

avatar

avatar
Contributor

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 attributesupdate 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.

avatar

@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.