Replace null values in cell

Question

I am unable to replace null values in cells. I have created a facet to only display cells that have null values. I then went to edit cells > Transform function and tried to use the replace function but it does not seem to be working.

Different things I have tried:

replace(value, null, 'other_text')
replace(value, 'null', 'other_text')

I expected the null values to be replaced with 'other text'

Screenshot:

Answer 1

You are not replacing the value null, but the string 'null'. The correct syntax for replacing is value.replace('old','new') or replace(value,'old','new'). But replacing doesn't work on null. You should either create a facet for null-values (your current screenshot shows some non-null-values) and fill the expression field with 'new' or you could do something like if(value==null,'new',value).