Error in adf If activity

Kenaniah Santhosh 6 Reputation points

I want my if condition to check if the value of Run_status column is equal to 0. If it equals to zero, it it has to exit until loop and move to next job. If not, it has to run in a loop inside until activity. I'm not able to implement this logic. Even before the value turns to 0, it has moved to next job, which is wrong. Inside my if condition, I have added this -> @equals(activity('Lookup2').output.firstrow.RUN_STATUS,0). I feel like there might be a mistake in this statement. Also, the select query which I have mentioned in lookup will give the result of Run_Status column.
Please help me with this

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,726 questions
1 vote

1 answer

Sort by: Most helpful
  1. Nasreen Akter 10,616 Reputation points

    Hi @Kenaniah Santhosh ,

    Would you please try to set the UntilFlag as @bool('True') and try again. Thanks!

    1 person found this answer helpful.