Dynamic update of column name
PARA
Registered Posts: 7 ✭✭✭
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.
Answers
-
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)
