0

IN operator in Pyramid Formulate (Custom Column)

Hello,

What's the best way to setup an IN operator in Pyramid formulate ?

For e,g. I want to be able to do something like

if (colvalue in ("10","11"....))

I know I can do this via multiple ORs but if the list is too long, what other options do I have ?

Thanks

Mad

3 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 1 mth ago
    • Reported - view

    Hi  ,

    Try HasItem().

    See Help: https://help.pyramidanalytics.com/Content/Root/developer/reference/fx/PQL/Common/String/HasItem.htm?Highlight=hasitem 

    Hope that helps.

    Ian

    • imbarmarinescubar_pyram
    • 1 mth ago
    • Reported - view

    Hello  ,

    Pyramid does not have an "in" function.
    The 2 possible ways to write this would be:

    IF([col] = "10" or [col] = "11" or... , "GOOD", "BAD")

    or

    SWITCH([col],
    "10", "GOOD",
    "11", GOOD"
    ...
    "BAD") // default

    You can suggest adding "IN" as a function in the product ideas section.

    Imbar

      • Mad_Amruthur
      • 1 mth ago
      • Reported - view

       Thanks Imbar, I have used that in cases where the list is small

Login to reply

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 31Views
  • 3 Following