how to load empty strings from apache nifi to postgres as null values?

user_19031918 0
Viewed 76

I have a json file file that contains some empty strings:

enter image description here

I have changed them by null using regex expression on ReplaceText :

enter image description here

Then i transformed the Json to CSV using Convert Record:

The final step was loading the csv to postgres db.

i got this result:

enter image description here

But i don't need the empty string in the database i need the Null value:

enter image description here

Have anyone an idea that can help me solve that issue ?

apache-nifi postgresql
0 Answers
Related