How to Pass Null Value in Parameter while creating new derived column in ADF Data Flows

Swapnil Kalkar 66 Reputation points
2020-11-23T08:43:38.957+00:00

Hello,

How to Pass Null Value in Parameter while creating new derived column in ADF Data Flows?

I am able to pass blank or any other default value ex. '' or 'Source1'.

but unable to pass null.

Please help in this regard.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,239 questions
0 comments No comments
{count} votes

Accepted answer
  1. MarkKromer-MSFT 5,216 Reputation points Microsoft Employee
    2020-11-23T21:19:05.153+00:00

    41956-image.png

    Add a pipeline parameter as a String, then use a Data Flow expression like: toString(null())

    5 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.