We are currently using DataStage for ETL processing. We have lot of custom scripts to transform the data - eg

if value of this column is X then set the value to XX

We are in the process of replacing DataStage with Azure Data Factory.

Does Azure Data Factory has the capability to use the custom scripts for Transformation? If so, any reference.

CodePudding user response：

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

Example: