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...

       

      LOAD

          "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",

          PAYER_GROUP

      FROM [lib://DATAMART BACKUP/INSAGINGDETAIL_2017.csv]

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

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

       

      Thanks in advance.