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

    Data editor and WHERE IN

    John Schmidt

      Hi,

       

      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:

       

      LOAD

        *

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

       

      WHERE (my_field NOT IN (20, 30)

      ;