Condition is false but step is still executed

[jashmore]

Hi - I need help please on a strange situation...

I have a simple IF condition checks if an integer variable is greater than zero.  When I run the job I can see that integer is in fact zero, and that the condition evaluates to false, but it is still executing the steps within the condition.   

As a test to make sure the steps were truly nested within the condition, I changed the condition to if true equals false, which evaluated to false as expected, and skipped the contained steps, as expected.  

I've also tried not equal to zero > condition is false as expected but the steps are executed.  And just for fun equal to zero > condition is true as expected and steps are executed as expected.  

Has anyone seen this before where it goes into the steps even when the condition fails?  Thanks in advance!

[gary1 · Accepted solution]

I think I need to see more of the recipe to get a better idea of what's happening. Here are some thoughts:

1. Dupe the recipe and re-run it. This sometimes fixes "illogical" behavior.
2. Add a logger inside the conditional to capture RowCount. Something funky is happening there. Do you have another RowCount variable somewhere in the recipe?
3. Try recreating RowCount as a different variable. Maybe a variable schema thing?
4. If this recipe segment is within a loop, there might be something else happening, but I can't really see.

[gary1]

Can you share how the condition is written and maybe a screenshot of the input and output?

[jashmore]

[jashmore]

The screenshots didn't upload in order unfortunately, but there are 6 screenshots.  3 screenshots defining the RowCount variable, the condition and the RowCount2 variable... and 3 screenshots inspecting RowCount, the condition and RowCount2.  Thanks for taking a look!

[gary1]

Is this running within a loop?