4 Replies Latest reply: Feb 5, 2018 12:03 PM by youssef belloum RSS

    Filtering for Multiple Items in the Load statment

    Ashley Kuttler

      Hello I am trying to filter for multiple items  in my load statement.

      I've tried Where Exists & Where IN and it doesn't accept either...



          "Date of AR Run",

          "Practice Name",

          "Insurance Name",

          "IB 30",

          "IB 31 to 60",

          "IB 61 to 90",

          "IB 91 to 120",

          "IB Over 121",

          "Total IB",



      (txt, utf8, embedded labels, delimiter is ',', msq)

      WHERE Exists("Practice Name", 'Derm 1', 'Derm 2', 'Derm 3')


      Thanks in advance.