Explore Courses Blog Tutorials Interview Questions
0 votes
in Azure by (17.6k points)

I have a data factory that reads from a table and stores the output as a CSV to Blob Storage.

I have noticed that instead of leaving a NULL field blank it inserts the NULL character \N.. Now the external system that is ingesting this can't handle \N.

Is there any way in my dataset where I can say leave nulls blank.

Below is my dataset properties:

  "typeProperties": {

        "fileName": "MasterFile-{fileDateNameVariable}.csv",

        "folderPath": "master-file-landing",

        "format": {

            "type": "TextFormat",

            "columnDelimiter": ",",

            "firstRowAsHeader": true


        "partitionedBy": [


                "name": "fileDateNameVariable",

                "value": {

                    "type": "DateTime",

                    "date": "SliceStart",

                    "format": "yyyyMMdd"





Thanks in advance. 

1 Answer

0 votes
by (47.2k points)

We just need to set the Null Value to " " when we set the dataset.

Browse Categories