Alternative to ISNULL() Function in Formula In-DB Tool

Looking for a way to handle Null values in database using the Formula IN-DB tool. Have over 100,000,000 rows so streaming the data out is not an option. Tried: ISNULL("METRIC_COLUMN","REPLACEMENT_METRIC_COLUMN_FOR_NULL_VALUE") and it did not work. Anyone know how to get the ISNULL function to work in the Formula In-DB tool or a workaround for changing null values in the Formula In-DB tool? Thank you

Developer Tools

In Database

Interface Tools

In-Database

Accepted answers

I actually just figured it out. Had to change it to "is Null" in a Case statement and it worked

All comments

you have to write this in the specific sql dialect of your underlying DB--- IE what's your database?

it's probably something along the lines of:

CASE WHEN "Metric Column" IS NULL

THEN "REPLACEMENT_METRIC_COLUMN_FOR_NULL_VALUE"

ELSE "Metric Column"

END

I actually just figured it out. Had to change it to "is Null" in a Case statement and it worked

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703