Using Operators in If Stmt

Hi Team,

Am trying to run Multiple queries and the output is thrown if threshold is crossed.
I have a control file, but not sure how to mention the “Operators(<,=,>= etc)” in the if stmt from the control file.


It looks like the operator is to parse from the Threshold column along with the number as well.
Here can regex help for parsing the operator and digit:
getting the operator:

getting the digit:

as we do need to do the compares on e.g. int base we just convert the number string to integer
Applying the different operators we can do with a switch and the result of it we can use in the if else activity:

Find some starter help here, implementing a skeleton of the above described approach:
ApplyCondition_AsStringInDT.xaml (11.9 KB)

1 Like

Thanks @ppr

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.