Drilling Down From Venn Diagrams - 17.1

To view join rows and values from a Venn Diagram

1. On the navigation menu, click Data Discovery > View Joins.
2. Run a search to find the join analysis you want to view. See Searching Joins.
3. On the Join Analyses tab, double-click a row to open a Venn Diagram for the join. The Venn Diagram shows information related to the first join highlighted on the Joins tab. To open information about a different join, double-click another row.

   Figure 1. Venn Diagram example

4. In the Venn Diagram, each segment includes numbers that represent the matching or non-matching rows and values in the join. Click the numbers to open tab views showing data rows and unique data values for the segment. If the number is 0, no drill-down is available.

   Row tabs open in the following state to help you review the data row results:

   • The columns showing the left and/or right data source ID values are locked on the left side of the tab view. These can be unlocked as needed.
   • All attribute columns (except data source ID) are color-coded to match the left and right side of the Venn Diagram. This allows you to quickly see which side of the join an attribute belongs.
5. From any values tab, double-click a row to open a tab showing the associated data rows.
6. (Optional) To export row and value information to your local system, on the row or value tab, select one or more rows and click Export Rows. See Exporting Joins.