question 1: Custom SQL for Excel and text files is not supported currently on Mac. This is because Custom SQL uses the MS JET driver for accessing the file, which is not available on Mac. See here (p.13/14 - Designing Efficient Workbooks | Tableau Software) if you need more information on that.
question 2: I already raised this topic at the beginning of the beta phase (here). The answer from Tableau is that it might become part of beta 3. But if this is still not part of the final release (can't test it until now), I'm also interested if this gets fixed in one of the maintenance release or if we have to wait until 8.3.
1 of 1 people found this helpful
For question 2, the Data > Convert to Custom SQL command will change your existing join structure to custom SQL. However, since Tableau now allows joining between tables and custom SQL, you may be able to use custom SQL for just some of the tables rather than all of them.
Thanks Dan! That's great! I don't think anyone that doesn't work for Tableau knew that was there.(And some that do work for Tableau don't know it's there)
In my years of using Tableau I've never clicked the "Data" menu item while in the connection window. Seems very redundant and I wonder why something like this isn't just a button on the UI?
Previous Tableau versions' Data Menu options:
Hence the reason I wouldn't think anyone would know to look there.
Thank you again. Now I'll just patiently wait for the Mac flat file connector to get custom SQL :-)