I would need to run two wherecontains within this dictionary array, for example to get a country with a POPULATION greater than 1,000,000 and an AREA greater than 150.
how can I proceed with two wherecontains?
thanks
Discussion posts and replies are publicly visible
index( local!data, intersection( where(local!data.POPULATION>1000000), where(local!data.AREA>150) ), null)
but should work in and condition
Yes the intersection function will return the common index which satisfies both population check and area check.
amazing! thanks sreedevijr