Dynamic update of column name

PARA
Level 1
Dynamic update of column name

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.

0 Kudos
1 Reply
fchataigner2
Dataiker

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)