Datafactory V2替换"\ N"空值，带空白 [英] Datafactory V2 Replace "\N" null value with blank

问题描述

当前在Azure Datafactory V2中，平面文件输出的默认null值设置为"\ N"，这会导致下游进程失败，因为datafactroy创建的浮点，整数或十进制值设置为"\"的平面文件N".

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".

在数据工厂数据集的高级功能中，我们可以将null值设置为某个字符:

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

我可以将其设置为什么值，以便仅允许使用空格而不是"，空格或其他会引起问题的字符?

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?

推荐答案

只需删除\ N并将输入框留空即可实现此目的.

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

您还可以在UI中单击 code 按钮(以下屏幕截图的右上角)，以查看数据集的json有效负载.

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.

这篇关于Datafactory V2替换"\ N"空值，带空白的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！