4 Replies Latest reply on Aug 24, 2016 10:26 AM by Jacob Anderson

    what is the differences between Data Blending and Joining the Tables?

    khadeer.shaik.0

      Hi All,

       

      • what is the difference between Data blending and Joining The Tables?
      • When we go for Data Blending?
      • when we go for Joining?
      • when we are Unable to Blend the Data form two or more Data Sorcues?
      • when we are Unable to Join the Tables?

       

      I am trying to get  more knowledge on these topics, Please help me?

       

       

       

       

      Thanks & Regards

      Khadeer

        • 1. Re: what is the differences between Data Blending and Joining the Tables?
          Elliott Stam

          Hi Khadeer,

           

          Let's answer these questions one by one:

           

          1) The difference between joining and blending data:

           

          Joining your data can only be done when the data comes from the same source, for example from two sheet tabs within a single Excel file. If that same information was stored in separate Excel files you would need to do a data blend in Tableau. A blend is always required if the data is stored in two separate "data sources" within Tableau. So even if your data is very closely related and exists in two separate files or databases, you will have to do a data blend if you are combining the data in Tableau.

           

          When blending data, the first data source used in your view will dictate how your worksheet view in Tableau is built. The secondary (blended) data source will be able to contribute extra information, but will not be able to change the overall structure of the view. The secondary data source's values can be aggregated and applied to the existing view after you have established a "relationship" by assigning a variable that both the primary and secondary data sources have in common.

           

          2) When to use data blending:

           

          It is generally preferable to avoid data blending when you can combine the two data sources outside of Tableau. If this is not an option, then you must identify at least one common variable shared by the two data sources you want to blend together. When possible, go for a join rather than a blend. If you need to combine two data sources and for whatever reason cannot manage to join the data outside of Tableau, your only option is a data blend.

           

          A simple example is having (a) a data source with three columns including location names and latitude/longitude values, and (b) a data source with location names and detailed information about each location. You could build a map using (a) and then blend in extra supplemental information using (b), where a relationship is built by connecting the data sources based on the location names.

           

          3) When to use joining:

           

          You can only use joining when your data comes form the same underlying source (for example, the same Excel file or Access file).

           

          4) When are you unable to blend data from two or more sources?

           

          If there are no variables shared between each data source then you will not be able to do a data blend, because there is no information that can be related from one source to the other. However, this does not mean that the column headers (variable names) need to be an exact match. You can edit the relationships manually to point Tableau to the variables that have matching underlying values.

           

          For example, if I am blending information together based on countries and source (a) calls it "Country" while source (b) calls it "Locations", I can edit a relationship manually to blend on these two variables. If the two column headers are an exact match, Tableau may automatically establish the link for you.

           

          4) When are you unable to join data?

           

          If the data comes from different underlying files you will not be able to do a join within Tableau. I recommend preparing your data before importing it into Tableau (there are many great tools available, one being Alteryx, that can help with this). In my opinion blending and joining in Tableau should be a last resort for times when you are unable to shape your data into one coherent file for analysis.

           

          I hope this helps. Best of luck!

           

          Elliott Stam

          InterWorks

          16 of 16 people found this helpful
          • 2. Re: what is the differences between Data Blending and Joining the Tables?
            khadeer.shaik.0

            Hi Elliott Stam,

                                    Thank you for your valuable time for giving answer to my questions.

             

             

             

            Thanks & Regards

            Khadeer

            • 3. Re: what is the differences between Data Blending and Joining the Tables?
              shaik noor

              HI Guys,

               

              We can use joins to join multiple data sources this feature is available in tableau 10

               

              Thanks & Regards,

              Noor.

              4 of 4 people found this helpful