Hi all, I wish to compare the values of two variables in an IF statement, and thought that the "Advanced" option would suffice, but there is very little documentation on the correct use of syntax. Any advice would be greatly appreciated

Matillion ETL
1

So I have two "Job Variables" that each contain the record counts from two separate tables. I want to see if subtracting one from the other equals to "0". If TRUE, then Orchestration job continues.

 

Happy New Year to all.

 

Kind regards

 

Martyn

2

Hi Martyn, you should be able to do this in the IF flow task. When you are in advanced mode, the expression would be something like this: ${VariableWithFirstCount} - ${VariableWithSecondCount} > 0

 

I am not certain but the variables with the counts, might need to be numeric.

 

Hopefully this helps and Happy New Year to you as well.