1

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.

Improve this question
1
  • Yes, in data flow we can write expressions to achieve this. Commented Jan 16, 2022 at 14:26

1 Answer 1

Reset to default
2

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.