Getting status of "If Condition" Activity into a variable

[sreedata]

"If Condition" has lot of activities that can succeeded or fail. If any activity fails then whole "If Condition" fails. I have to get the status of the "If Condition" activity (pass or fail) so that i can use it for processing in the next notebook that follows it.

Please suggest some ways

Thanks

[Hubert-Dudek]

Can you share your code? I don't know if python, SQL, or some logic in orchestration tool.

In python, you would need to set try catch in every if statement and use dbutils.notebook.exit('message') to handle it in another notebook.

[sreedata]

dbutils.notebook.exit('message') .This is also a good way .But since my if activity has multiple notebooks it would get complicated.So setting base parameters from success and fail path helped

[UmaMahesh1 · Accepted solution]

In your ADF Pipeline activity, set two different pipeline activities from the If condition activity based on success or failure (the green and red arrows).

Then inside each pipeline activity, you can add a set variable, get variable and your adb notebook activities. In set variable, you would be setting the status of your activity using the standard pipeline parameters.

Hope this helps...Cheers..

[sreedata]

Thanks .This helped.Set a base parameter to the notebook with status sucess or fail