Overlap analysis results can be viewed in a grid, as thumbnails, and in graphs.
Grid View
The Overlap view of an analysis contains the following data, depending on the options you selected.
Name | Type | Definition |
---|---|---|
xidx | FLOAT | Generated table identification number. |
xdb | VARCHAR (128) | Database that the variable for the overlap operation resides in, as specified by the database parameter. |
xtbl | VARCHAR (128) | Table that the variable for the overlap operation resides in, as specified by the table parameter. |
xcol | VARCHAR (128) | Variable that the overlap operation runs against, as specified by the column parameter. This is comma-separated if you select two or more columns. |
xcnt | VARCHAR (50) | Total number of occurrences of this variable. |
xunique | FLOAT | Total number of rows where this variable takes a unique value. |
N number of tables selected | FLOAT | Total number of column overlaps between crossing tables. |
Graph View
The Overlap graph is a vhann chart, where the middle is where both tables overlap. It is displayed in the Graph View tab.