11 Replies Latest reply: Aug 12, 2017 8:15 AM by Sasidhar Parupudi RSS

    Select Example where example2 = 'Ex1' or 'Ex2' ...

    Nicholas Reardon

      I'm trying to load a table called "NAGM" and my code looks like the following-

       

      NAGM:

      Select [Manufacturer]

      where Manufacturer = "Manu"

      and Platform = "HUEY" or "JOHN" or "Eric" or "BENJAMIN" or "CAROL" or "LEE"

      FROM [lib://AttachedFiles/Copy Pasted Current Report.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      What am I doing wrong?