If you’re working in Azure Data Factory or are just starting out with it, today I’m here with a quick design tip when it comes to Azure Data Factory pipelines.

 

In a scenario where you’re using a ForEach activity within your pipeline and you wanted to use another loop inside your first loop, that option is not available in Azure Data Factory. If you look at the screenshot below, you can see that the option to add an additional ForEach loop is not available.

NestingForEachLoopsDataFactory

So, here’s my design tip – if you have a scenario where you want to do a loop inside a loop, you would need to create an additional pipeline as a separate object. And in that second pipeline is where you would put your second loop.

Again, looking at my screenshot, I’m working in the context of one ForEach loop and so this pipeline will be executed one time for each item in my list but that pipeline, in turn, is where I have an additional ForEach loop.

Hope you find this quick design tip helpful if you run into this scenario.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].