CODEWITHSUNDEEP
azureazure-data-factorydataflow
Vesela Kosturkova
Vesela Kosturkova

Reputation: 41

Azure data factory dataflow not present null values in JSON format

I am looking for how to present my null values with the Azure Data Factory Dataflow activity. Currently, I am using standard dataflow for modelling my data from Azure SQL database and drag it into Blob storage in JSON format. But if the dataset source has a null value, the column in the row is skipped in JSON.

UPDATE: Here is the results of having data, having entry string as data and null value.

Please, give me some advice on how to proceed, in order to resolve the problem. With Copy activity I don't have the same issue - null values are presented with ""

Thanks in advice! Cheers, Vesela

Upvotes: 1

Views: 6274

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

I now have a solution, you could reference it.

I recreate a table with the schema like bellow, column setNum has null value:

enter image description here

In the Data flow, I added a DerivedColumn to help us convert the null value to ''.

enter image description here

Expression: iifNull(setNum,''): if the setNum is null, then replace it with ''.

enter image description here

Now, run the pipeline, enter image description here

Check the data in blob:

enter image description here

Hope this helps.

Upvotes: 2

Related Questions