New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

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
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)

A banner prompting to get Dataiku DSS