Support Questions

Find answers, ask questions, and share your expertise

Transform a float value into integer using JoltTransformJSON in NiFi

avatar
New Contributor

Hello! 

I'm trying to convert float values on my flow files into integers. My Jolt Specification looks like this:

[
{
"operation": "modify-default-beta",
"spec": {
"progress": "=toInteger",
"setup_value": "=toDouble",
"proposed_setup_cost": "=toDouble",
"real_setup_cost": "=toDouble",
"invoiced_value": "=toDouble",
"last_recognized_value": "=toDouble",
"starting_date": ["=toDateTime", "yyyy-MM-dd HH:mm:ss", "coerceOrNull"],
"last_progress_change": ["=toDateTime", "yyyy-MM-dd HH:mm:ss", "coerceOrNull"],
"end_date": ["=toDateTime", "yyyy-MM-dd HH:mm:ss", "coerceOrNull"]
}
}

But somehow my "progress" value is still being outputted like a float. If I have the value 100.0, it is not transformed to 100, for example. I also tried using "=toInteger(@(1,value))", but that also didn't worked.

1 REPLY 1

avatar
Community Manager

@enguias Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our NiFi experts @MattWho @SAMSAL  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: