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

    rawsql_str() got error "no such function"



      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])



      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?