JOINS IN TABLEAU
JOIN IN THE TABLEAU
JOIN : JOIN IS QUERY / CONDITION COMBINES THE DATA FORM 2 OR MORE TABLES/SHEET/FILES WITH IN SINGLE DATASET /MULTIPLE DATA SET /DATASOURCE
2 RULES
1. SHOULD HAVE COMMON COLUMNS
2.BASED ON THE COMMOM DATA TYPE IN THE BOTH TABLES
JOIN TYPES
1 EQUI JOIN
2.NON EQUI JOIN
INNER JOIN OUTER JOIN SELF JOIN
OUTER JOIN
LEFT OUTER RIGHT OUTER JOIN FULL OUTER JOIN
INNER JOIN :COMBINE THE DATA 2 TABLES WHAT ARE THE MATCHEING RECODS OR COMMON RECORDS
LEFTOUTER JOIN : DISPLY THE LEFT OUTER JOIN AND WE ARE TAKING ENTIRE LEFT TABLEA AND WHAT ARE THE MATCHING RECORD FORM RIGHT TABLE
RIGHT OUTER JOIN : DISPLY THE RIGJT OUTER JOIN AND WE ARE TAKING ENTIRE RIGHT TABLEA AND WHAT ARE THE MATCHING RECORD FORM RIGHT TABLE
FULL OUTER JOIN : IT DISPLAY THE COMPLETE DAT FROM BOTH THE TABLES
SELF JOIN : JOIN IS THE SAME TABLE IT SELF IS KNOWS SEF JOIN