Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

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.