dataflow gen2 branching

arkiboys2 — Thu, 07 Nov 2024 15:56:36 GMT

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

Re: dataflow gen2 branching

frithjof_v — Thu, 07 Nov 2024 16:18:53 GMT

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?

Re: dataflow gen2 branching

Anonymous — Fri, 08 Nov 2024 05:39:54 GMT

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!

Re: dataflow gen2 branching

arkiboys2 — Sun, 10 Nov 2024 14:25:31 GMT

thank you

topic Re: dataflow gen2 branching in Data Engineering

dataflow gen2 branching

Re: dataflow gen2 branching

Re: dataflow gen2 branching

Re: dataflow gen2 branching