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

       

      Query:

       

      SELECT

      Order_string,

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

      Order_ID

       

      FROM ..

      WHERE ..