question Re: Transform string to integer in NiFi in Support Questions

Transform string to integer in NiFi

vatodorov19 — Wed, 04 Nov 2020 19:35:58 GMT

How can I transform a string to an integer in NiFi? I tried JoltTransform, but the string is transformed to a negative (??) integer. In the example, below, the timestamp_start original string value 1677720088000 is transformed to -1612124736. What am I missing in my Jolt specification? Any help is appreciated. Is there an alternative to the JoltTransform - another processor?

Looks like this is a known issue: https://github.com/bazaarvoice/jolt/issues/749

Original JSON

Transformed JSON

Jolt Specification

[ { "operation": "modify-overwrite-beta", "spec": { "timestamp_start": "=toInteger" } }, { "operation": "default", "spec": {} } ]

Re: Transform string to integer in NiFi

Faerballert — Thu, 12 Nov 2020 18:45:55 GMT

The problem is because your value is higher than the maximum of an integer

Change

"=toInteger"

"=toLong"

Re: Transform string to integer in NiFi

vatodorov19 — Fri, 13 Nov 2020 14:55:11 GMT

Thanks @Faerballert

Re: Transform string to integer in NiFi

kowalma7 — Fri, 18 Feb 2022 08:33:03 GMT

what if the value is empty. How to set null value instead of empty string ?