1 Reply Latest reply on Apr 6, 2016 10:32 AM by Daniel Vincent

    Convert SQL to Tableau Calculated field formula syntax

    Robert Priewe



      i'm trying to replicate a couple of OBIEE reports in tableau. Most of the calculated fields in OBIEE have a SQL syntax, eg:


      CASE WHEN "ID" IN ('1', '2', '3', '4') THEN 'A'

      WHEN "ID" IN ('5', '6') THEN 'B'



      Tableau doesnt support IN operators as far as I know, which means I would have to use an if formula and use OR for each number. My formulas are way longer which would take a lot of time.


      Is there a method to convert this to a tableau syntax? Referenced columns can just be converted to [ID] or somethting similar