Format
ReplaceNull(Arg1)
Returns
Returns the value of Arg1, replacing any null values in the collection with the last known value, if possible.
Whenever the function finds a null in the collection, it will first look for the last known value which is not null.
- If the function can find the last known value which is not null, then it will replace the null with the last known value.
- If the function cannot find a last known value, then it will look for the first known value (in the future) and replace the null with that.
- If this search fails and a non-null value cannot be found in either direction, then it will replace the null with an error:
(“The source null value has been replaced with an error as no other non-null replacement value was found.”).
Inputs
Arg1: The argument being checked for errors and lack of samples or data.
Behaviour: Required
Dimension: Collection
Valid data types: Null, Boolean, DateTime, Decimal, Integer, String, Duration, Error