1 Reply Latest reply on Nov 19, 2013 6:43 PM by Joshua Milligan

    Join tables using calculated field

    Harley Ellenberger

      I have a calculated field that is creating a string of two dimensions separated by a hyphen....

       

      Screenshot-2013-11-19_20.38.53.jpg

       

      This is effectively giving me a string field such as "CBS - HOW I MET YOUR MOTHER"

       

      I have a table in my database that I want to use to join to that calculated field.  When I try to set up the table join, my calculated field isn't available from my extract.....

       

      Screenshot-2013-11-19_20.40.38.jpg

       

      Any way to make that calculated field available to perform a join on?

        • 1. Re: Join tables using calculated field
          Joshua Milligan

          Harley,

           

          Row level (which yours is) and aggregate calculated fields are usually* calculated as part of the queries generated by Tableau, which are based on your data connection, including joins.  Therefore, you will not be able to use them as part of a join.  What is your source?  If you are able to perform the calculation in the source then you will be able to join.  Or you might consider using a custom SQL statement which concatenates the fields for the join.  Depending on what you need from the joined table, Data Blending might be an option to consider.  In the case of data blending, you can use a calculated field to link the tables.

           

          Regards,

          Joshua

           

           

          *Row level calculations may be materialized in extracts.