Pipeline Builder - find and replace null values

Ask the Community
1

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

2

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.

2 Likes