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

[BobbyQ]

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

[apathetichell]

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

[apathetichell]

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

[BobbyQ · Accepted solution]

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