Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

removing scientific notation after divison

Explorer

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

Super Collaborator

Explorer

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.

Super Collaborator

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.