- On the Variable Transformation dialog, click on INPUT.
Click on primary key.
Variable Transformation > Input > Primary Key
The purpose of this window is to specify the columns that comprise the primary key of the input table or view being transformed. This is required only when null value replacement is requested in one of the requested transformations.
If input comes from a table the primary index, columns of the table will be selected by default. To change these columns, or to enter them initially if input is from a view, use the selectors as described below.
- Available Tables — Pull-down with the name of the input table or view.
- Available Columns — All columns within the table or view selected in Available Tables. Highlight those columns which comprise the primary key of the table or view and either drag and drop them to Selected Primary Key Columns, or use the right arrow button > to move them over.
- Selected Primary Key Columns — All columns within the table or view that constitute the primary key (that is, that uniquely identify each row). If undesired columns were moved into this area, highlight those columns and either drag and drop them back to Available Columns, or use the left arrow button < to move them back.