Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I use this query to check null values and tag it as pass or fail "if(isNull(Name),0,1)" is there a facility where i can dynamically change the column names in the expressions.
Hi,
that's the goal of the `val(...)`, `strval(...)` and `numval(...)` functions: they take a column name in, and return the value for that column. For example your current expression can be written as
if(isNull(strval("Name")), 0, 1)