2 Replies Latest reply on Feb 28, 2013 1:17 AM by Jurien Groot

    #error in results with custom MySQL query

    Jurien Groot

      I am running a query on Tableau 7.0 desktop and get #error results. Find attached a screenshot.


      If I run the same query on Tableau 8.0 or Navicat I get normal results. I tried to re-install MySQL driver, but didn't help. Any idea is much appreciated, since I need this query to work






      SUBSTRING_INDEX(SUBSTRING_INDEX(Order_string, 'xx=', -1), '&', 1),



      FROM ..

      WHERE ..