8 Replies Latest reply on Jun 27, 2018 3:21 PM by Hari Ankem

    Help with filter formula

    Alyssa Ashton

      I'm having trouble with filters with OR, wildcards, and multiple fields.  How do I write the below SQL in Tableau?

       

      AND PG.GL_Specialty NOT IN ('03', '04', '07', '13', '14')

      AND ((PG.GL_Specialty = '06' AND S.Specialty_Description LIKE '%hospitalist%') OR PG.GL_Specialty <> '06')

      AND ((PG.GL_Specialty = '12' AND S.Specialty_Description LIKE '%surg%') OR PG.GL_Specialty <> '12')