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.
Capture

@hss

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:
grafik

getting the digit:
grafik

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.