Hi forum,
What is the best way, in Pipeline Builder, to replace null values in a column with a string. Regex replace can replace empty strings, but that seems to find and replace all instances of a single string
Hi forum,
What is the best way, in Pipeline Builder, to replace null values in a column with a string. Regex replace can replace empty strings, but that seems to find and replace all instances of a single string
You can replace null values with coalesce
/first non null value
.
https://www.palantir.com/docs/foundry/pb-functions-expression/firstNonNullV1/
You can do coalesce(column("columnName"), "my_value_when_null")
for example.