0

SQL "in" Operator in Klipfolio

Hi Guys,

does klipfolio have an operator which works like the "in" operator in SQL. 

 

Our formular would be: 

Select ([Field1], and([Field2]="2019",[Week] = (36, 37, 38))

respectively 

Select ([Field1], and([Field2]="2019",[Week] = !ColumnofanTableWithMultipleValues)

 

1 comment

  • 0
    Avatar
    Janice Janczyn

    Hi Markus,

    Yes, Klipfolio has an IN function. Following your example, in Klipfolio you would use

         SELECT( Field1, AND( FIELD2 = 2019, IN( Week, ARRAY( 36, 37,38 ) ) ) )

    and

         SELECT( Field1, AND( FIELD2 = 2019, NOT( IN( Week, @ColumnofanTableWithMultipleValues ) ) ) )

    Thanks,
             Janice

Please sign in to leave a comment.