Skip to main content
M
matteos1776
June 26, 2024
Question

Double Wherecontains

  • June 26, 2024
  • 4 replies
  • 0 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

    4 replies

    S
    sreedevij0074
    June 26, 2024

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

      M
      matteos1776Author
      June 26, 2024

      but should work in and condition

      S
      sreedevij0074
      June 26, 2024

      Yes the intersection function will return the common index which satisfies both population check and area check. 

        Terms & ConditionsAccessibility statement