.png%3Falt%3Dmedia%26token%3D8174d25a-bbf3-43b6-9e21-3b022d5cd5ec)
.png%3Falt%3Dmedia%26token%3D8174d25a-bbf3-43b6-9e21-3b022d5cd5ec)
FILTER_UNKNOWN
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 modified 1yr ago