How To Use Switch Statement in Azure Data Factory Pipeline

This article explains how to use switch statement in ADF pipeline instead of multiple if-else activities.

As a Data Engineer, I have had many use cases wherein I needed to use multiple if-else conditions as part of my data pipeline. What I found was that ADF doesn’t support nested if-else statements as well as I’d have imagined/assumed. You can either use many if-else conditions or use one switch activity. Here, I will give you a practical example that uses switch activity.

Use Case:
Multiple datasets