dataflow gen2 branching

[arkiboys2]

similar to ADF dataflow where there is branching activity, is there a similar option in gen2?

for example:

step --> step2 --> step3 --> step4 --> step4a1 --> step4a2...

                                                        --> step4b1 --> step4b2

thanks

[Anonymous · Accepted solution]

Hi @arkiboys2 ,

Thanks for the reply frithjof_v .

You need to edit the M code in the Advanced editor.

A similar use case is below:

let
  Source = Lakehouse.Contents([]),
  #"Navigation 1" = Source{[workspaceId = "y=YourWorkspaceId"]}[Data],
  #"Navigation 2" = #"Navigation 1"{[lakehouseId = "[YourLakehouseId"]}[Data],
  Navigation = #"Navigation 2"{[Id = "Sales", ItemKind = "Table"]}[Data],
  #"Inserted conditional column 1" = Table.AddColumn(Navigation, "Custom", each if [SalesID] = null then "" else ""),
  #"Added custom" = Table.AddColumn(#"Inserted conditional column 1", "Custom (2)", each if [Amount]>1000 then 1 else 0),
  #"Added custom2" = Table.AddColumn(#"Inserted conditional column 1", "Custom (2)", each if [Amount]>2000 then 1 else 0),
   #"Added custom3" = Table.AddColumn(#"Inserted conditional column 1", "Custom (2)", each if [Amount]>3000 then 1 else 0)
in
  #"Added custom3"

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[arkiboys2]

thank you

[frithjof_v]

I don't have experience with ADF dataflow, but do you mean take different routes depending on an IF statement?

Yes that's possible. You will likely need to edit the M code in Advanced editor.

Do you have a specific use case?