Double Wherecontains

4 replies
29 views

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

S

sreedevij0074

Inspiring

index(
    local!data,
        intersection(
            where(local!data.POPULATION>1000000),
            where(local!data.AREA>150)
            ),
null)