5 Replies Latest reply: Aug 1, 2017 6:18 AM by John Schmidt RSS

    Data editor and WHERE IN

    John Schmidt



      i am fetching data from a QVD in the data editor and i would like to perform a SQL equivalent of WHER IN.

      Can anybody tell me how to do this?


      Basically like this:




      FROM [lib://MyFolder/test.qvd] (qvd)


      WHERE (my_field NOT IN (20, 30)