- On the Scatter Plot dialog box, click on INPUT.
-
Click on join columns.
Scatter Plot > Input > Join Columns
This screen contains the join columns for the tables or views selected in the data selection panel. The join columns are used to join together the tables or views containing the requested columns whenever columns from more than one table or view are being analyzed in the graphics interface. The same number of columns must be present for each requested table or view, as they are matched by position, one for one.
If possible, the join columns are by default set automatically to the primary index columns of the requested tables. The primary index columns cannot be determined automatically for requested views.- Available Tables — Each table or view that contains the columns which the Scatter Plot analysis will be executed against. The table or view names are qualified (preceded) by the name of the database that contains them.
- Available Columns — The columns that are candidates for “join columns” that should be used to join together the tables or views that contain the requested columns. Select columns by highlighting and then either dragging and dropping into the Selected Join Columns window, or click on the arrow button to move highlighted columns into the Selected Join Columns window.
- Selected Join Columns — The columns that should be used to join together the tables or views that contain the requested columns for scatter plot analysis. The same number of columns must be present for each requested table or view. When joining tables or views together, the join columns are matched one to one in the order listed.