2 Replies Latest reply on Aug 19, 2013 5:46 AM by sirajmandayippurath

    Multiple data sources, relationship field must be dimension?

    Frank Maduri

      Hello,

       

      I think I have answered this question myself, but would appreciate a 2nd opinion.  I have an ACCESS DB and Excel file.  The common join field is ID, which is numeric, and appears as a measure.  When I tried to edit the relationship, these elements didn't show up.  I changed them to dimensions and was able to do the join without a problem.

       

      Is this the correct solution?

       

      Thanks.

       

      Frank

        • 1. Re: Multiple data sources, relationship field must be dimension?
          Shawn Wallwork

          Yep, you can only join on dimensions, as far as I know. ID fields should usually be dimensions because you normally won't want/need to aggregate them. When you first connect to your data Tableau takes a look at the first record below the header and makes a guess at whether to make a field a dimension or a measure, which is why IDs get posted as measures (they are numeric). But these data windows are only the defaults, which you can change by dragging fields between the two windows.

           

          One oddity in this dragging between the windows is that while you can NOT drag a date type to the measure pane, you can drag a date to the viz and then convert it to measure CNT(Shipping Date) for instance. Why? Who knows. Just one of those T inconsistencies to remember.

           

          --Shawn

          • 2. Re: Multiple data sources, relationship field must be dimension?
            sirajmandayippurath

            Hello Frank,

             

            You've got the correct approach. Data Blending is done across common dimensions. From your explanation here, I believe that ID is a dimension field anyway. Tableau is placing this field in the measures pane because of the data type. As you have rightly pointed, change the measure to a dimension (drag and drop) and then use it for the blend!

             

            Happy Blending! :-)

             

            Cheers

            Siraj

            1 of 1 people found this helpful