2 Replies Latest reply on Aug 16, 2012 9:13 AM by Laura Kazan

    data won't blend

    Laura Kazan

      I am a newbie so sorry if this is obvious.

       

      I am having trouble blending data. I have data from two different data sources - Excel and SQL Server. They have the same name. I have checked to make sure that the relationship exists in the data drop down menu and it says that it does, the data types are the same. Still I am not getting the link in the demensions list and the relationship is not recognized. Any ideas why this would be.


      Thanks for any help

        • 1. Re: data won't blend
          David Roers

          Blending is tricky.  I think you'll need to include a packaged workbook (or publish one to Tableau Public).

           

          The 'join' accomplished by blending is a LEFT JOIN, meaning that the combined set will include all rows from the primary source and only the rows from the secondary source that match on your key field(s).

           

          One thing to try: Be sure to add one of the common dimensions (one of your key fields) from the primary data source, before trying to add anything from the secondary source.

          • 2. Re: data won't blend
            Laura Kazan

            Thanks David. After experimenting I discovered what you said here - you have to add the common dimension from the primary data field before adding the second source. Once I did that my little link icon showed up. So I think I have the blending down. Thanks for your help. Now I have a new problem! Will start a new post if I need help with that one.

             

            Really appreciate the reply.