Dynamic update of column name

Options
PARA
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

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 Dataiker
    Options

    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)

Setup Info
    Tags
      Help me…