.png%3Falt%3Dmedia%26token%3D8174d25a-bbf3-43b6-9e21-3b022d5cd5ec)
.png%3Falt%3Dmedia%26token%3D8174d25a-bbf3-43b6-9e21-3b022d5cd5ec)
INTERSECTION
The INTERSECTION function returns the elements contained in both sets
p is Person
INTERSECTION(p.countries_lived_in, p.nationalities)
This would return countries the person has both lived in and has a passport of. So fa person that lived in Germany, Switzerland and Italy, but is only of German nationality, this would return Germany.
Last modified 10mo ago