Datafactory V2 Replace "\N" null value with blank

Viewed 5377

Presently within Azure Datafactory V2, the default null value for flat file output is set as "\N", which causes the downstream processes to fail as datafactroy is creating flat files with a float, int or decimal value set to "\N".

Within the advanced features of the datafactory datasets, we can set the null value to a certain character:

enter image description here

What value can I set this to so as to permit simply an empty space instead of a " ", blank space or other character that would cause issues?

1 Answers

Just remove \N and leave that input box empty will achieve this.

You could also click the code button (right top conner of the following screen shot) in the UI to see the json payload of the dataset.

enter image description here

Related