- On the Join dialog box, click on INPUT.
-
Click on join columns.
Join > Input > Join Columns
This screen is used to specify the columns on which to join together the tables or views selected in this analysis. For tables, the primary index columns are displayed as default values which may be changed. Join columns are matched for each table or view, one-for-one in the order specified. Each table or view must therefore have the same number of join columns specified.
The screen contains these fields:- Available Tables — All tables specified under data selection Selected Columns.
- Available Columns — All columns specified under data selection Selected Columns.
- Selected Join 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.