Data Discovery Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5.1
- 10.5

Back Next

Join Analysis Results

The join analysis

Results

tab provides information about the number and percentage of parent orphan rows, child orphan rows, and join rows. Join analysis results also include Venn diagrams that show the relationships between columns.

The following table describes the properties shown on the

Results

tab:

Property	Description
Left Table	Name of the left table and columns used in the join analysis.
Right Table	Name of the right table and columns used in the join analysis.
Left Only Rows	Number of rows in the left table that cannot be joined.
Right Only Rows	Number of rows in the right table that cannot be joined.
Join Rows	Number of rows included in the join.

Select a join condition to view a Venn diagram that shows the relationships between columns. The area below the Venn diagram also displays the number and percentage of orphaned, null, and joined values in columns.

Double-click a section in the Venn diagram to view the records that the section represents. These records open in the Data Viewer view.

You can export the list of records from the Data Viewer view to a flat file.

Join Analysis

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal