Join vs Relationships

Rajeswar Rayapati
1 min readJan 20, 2021

--

Difference between #Join and a #Relationship in #Tableau!!

Join is like a Marriage whereas a #Relationshipsintableau is like a relation between two Lovers

Why?

When married, both people lose their individual identities and form a new entity called Family. Same ways in Joins, Tables lose their #granularity and form a new granularity based on the individual #levelofDetail.

In a Marriage, somethings are lost right like they are no longer Bachelors, can no longer think as I but should start thinking as we

In the same way, in Joins, #Tables lose Data based on what type of #join we #select

When in Love, the individuals live at their own place of residence and their place of the meeting depends on the #Context.

In the same way, in #Relationships, each Table lies at its own #LevelofGranularity and the type of #Join is decided by the context of the View.

In the process of Love, they don’t lose their identity (Except for their Heart) and they are still individuals. Similarly, in Relationships, there is no #Dataloss (Sadly Tableau doesn’t have a heart but a brain)

P.S. — There is no much difference between Real life and #Databases (Esp Tableau)

#tableausoftware #tableaudeveloper #tableaudesktop #rayapatitableau #rayapati #joinstableau #relationaldatabases #relationshipstableau

--

--

Rajeswar Rayapati
Rajeswar Rayapati

Written by Rajeswar Rayapati

I am MAD about Tableau especially LODs. To spread that love on Tableau, I started Scenario Based Tableau Training. Call +91 9121314333 for details

No responses yet