How to use custom scripts in Azure Data Factory to Transform data?

Solution 1:

You can write the case expression in the Data flow derived column transformation in Azure Data Factory.

Example:

enter image description here

enter image description here