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

    Convert SQL to Tableau Calculated field formula syntax

    Robert Priewe

      Hi,

       

      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'

      END

       

      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

       

      Thanks,

       

      Robert