0

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 ?

ghilani
  • 33
  • 5
  • How do you load data into postgres ? If using COPY command, then there is option WITH NULL https://stackoverflow.com/questions/52212909/postgres-force-null-values-in-numeric-columns-with-copy – Kadet May 27 '22 at 08:53

0 Answers0