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

Question

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.

Answer 1

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