3 Replies Latest reply on Apr 19, 2012 5:28 PM by Dan Cory

    rawsql_str() got error "no such function"

      Hi,

       

      I was trying to use rawsql_str() with a MySQL database as in the following code

       

      IF ([Identify subscribers by]=="mobileId")

      THEN [v_DIM_subscriber_mobileid]

      ELSE RAWSQL_STR("REVERSE(%1)", [v_DIM_subscriber_reverse_msid])

      END

       

      But I got an error message from Tableau that says "No such function"

       

      I am sure MySQL has a function call REVERSE().  I also tried other MySQL string functions such as LOWER() but it also did not work.

       

      Did I do something wrong?