1 Reply Latest reply on Apr 30, 2018 1:37 PM by patrick.byrne.0

    Join <Null> to <Null> , Null = Null ? is it ?

    Karthikeyan Masialamani

      All,

       

      I am curious to know how tableau have an option to JOIN NULL to NULL. As A DB/ETL guy, I have never seen this option in DB or ETL, the best practice is to avoid NULL or replace null with some '' or 0 in the join or in any calculation. Two Nulls are not always equal - The basic mathra which I have heard/read/seen in DB.

       

      If Tableau allow to join Null to Null, how it identify say for example, I have 3 nulls in one table and 4 nulls in another table. which 3 nulls will be picked? how?

       

      which algorithm is used behind the scene? what is the exact purpose of having this option in Tableau?

       

      Thanks

      Karthik M

        • 1. Re: Join <Null> to <Null> , Null = Null ? is it ?
          patrick.byrne.0

          Hello Karthikeyan,

           

          I cannot speak to everything that you are asking above. But one thing I can clarify, is Tableau desktop will not make exclusively 1 to 1 releationship joins. Tableau Desktop can join with a many to one or one to many relationship, depending on what join type is selected. Thought the results of joining on a null might not be what you are looking for. Tableau allows as much as possible when it comes to connecting to the data as we do not know every use case out there. I am sure there is a scenario where someone wants to join to disparate data sources on a blank columnn. The precise logic behind this is a little bit beyond my scope of knowlege.

           

          One suggestion I would make is that when you are creating joins to fully research the different types to understand the results that are being returned more clearly.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick