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 ..
Feb 19, 2013 10:34 AM
Hi Jurien,
We have made a number of improvements to our MySQL connector in the upcoming Tableau v8 release, but these improvements cannot easily be carried back into the v7.0 product. If you cannot wait until the v8 release (I can't comment on a timeframe) then you should contact our Support team (support@tableausoftware.com) to try to find a workaround.
-Robert
Changing data type to varchar instead of text did the trick.
thanks