With FILTER_UNKNOWN you remove all unknown values from a list.


p is Person
FILTER_UNKNOWN([p.first_name, p.middle_name, p.last_name])

Here, we load three information from a person: first, last and middle name. The middle name here is optional, so will be unknown often. If the middle name is unknown, filter unknown returns a list of e.g. ['Peter', 'Parker']. If there is a middle name this could e.g. return ['James', 'Tiberius', 'Kirk'].

Last updated