6 Replies Latest reply on May 25, 2016 8:18 AM by Jane Mamas

    Join tables on calculated field, custom SQL?

    Jane Mamas

      Hi all,

       

      Is it possible to join SQL databases on a calculated field (calculated in Tableau)? Custom SQL?

       

      That's what required:

      Left join

      Calculated filed (from Tableau) = Field_A (SQL database)

       

      I temporarily solved the problem by creating an extract (Excel) and blending data,

      but 1. blending requires aggregation and isn't done at record level 2. I need connection to live database, not an extract 3. it slows Tableau calculations A LOT

       

      Tableau Desktop 9.3

       

      I'm completely stuck with my report and that option would help a lot.. so any ideas are greatly appreciated