Branching on the main canvas of data pipeline

[Ostrzak]

Hey everyone,

I might be missing an obvious connection, but is there a way to branch the pipeline on 3 conditions? "Switch" activity accepts multiple conditions, but doesn't accept boolean in an expression. "If" activity accepts boolean expression, but has only two conditions. Additionally they both require pipeline "nesting", where if the branching doesn't converge at some point, main canvas "ends" with the If activity and all the rest is hidden in the overview.

I get the idea that I can circumvent the switch, but I'm struck by the absence of a farily simple tool that redirects the flow on the main canvas and accepts several conditions of different types.

Apologies for complaining.

Best regards,

Jakub

[Nico_Saar · Accepted solution]

Depending on what you want to do after the branching you could use the "Filter" activity to handle this. Create multiple Filter activities that will be executed in parallel which lead to different activities being beformed depending on the input.

I used this once to decide depending on the metadata I was reading from a configuration table, which pipeline I want to trigger in the next step.

This approach was used in the Azure Data Factory btw. ... could use the Switch Activity in Fabric Data Factory nowadays. 

[Anonymous]

Hi @Ostrzak 

You can try using a combination of "Switch" and "If" activities to handle multiple branch conditions.

Add a "Switch" activity to the pipeline and set the expression. In the "Switch" activity, add three branches.

Perform different if activities according to different branches, if it is "true", the next step is performed, if it is "false", the end.

Switch activity - Microsoft Fabric | Microsoft Learn

If Condition activity - Microsoft Fabric | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.