Scatter Plot - INPUT - Join Columns - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. On the Scatter Plot dialog box, click on INPUT.
  2. 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.