Merge Options - Options Tab

Select the Options tab in the Merge Options dialog box to access the options described here.

Input. The Input group box contains options for selecting specific cases from both File 1 and File 2 for your merged output.

Use File 1 selection conditions/Data are sorted/Edit. Select this check box to allow selecting specific cases from File 1 to be used in the merge operation. When the Data is sorted check box is selected, STATISTICA expects the input spreadsheet to be sorted. Click the adjacent Edit button to display the Spreadsheet Case Selection Conditions dialog box where you can select the cases. Note that case selection conditions take precedence over any other options; this is to say, case selection conditions is the first item to be evaluated during the merge option.

Use File 2 selection conditions/Data are sorted/Edit. Select this check box to allow selecting specific cases from File 2 to be used in the merge operation. When the Data is sorted check box is selected, STATISTICA expects the input spreadsheet to be sorted. Click the adjacent Edit button to display the Spreadsheet Case Selection Conditions dialog box where you can select the cases. Note that case selection conditions take precedence over any other options; this is to say, case selection conditions is the first item to be evaluated during the merge operation.

Output. The Output group box contains output options for the merge operation.

Create new spreadsheet. Select this check box to route the merge operation to a new spreadsheet. Note that if this check box is not selected, File 2 will be merged directly into File 1.

Note: To keep the original data type for the key, clear the Create new spreadsheet check box. If you then match a key variable of type Double with Text Labels in File 1 against a key variable of type Text column in File 2, then the resulting key type (in the existing spreadsheet) will be Double with Text Labels.

Copy formatting from File 1. Select this check box to copy all cell formatting (e.g., font or background color) from the cases or variables that are copied from File 1 into the output spreadsheet. Note that this option only pertains to variable and case merging and is only enabled if the Create new spreadsheet check box is selected.

Copy formatting from File 2. Select this check box to copy all cell formatting (e.g., font or background color) from the cases or variables that are copied from File 2 into the output spreadsheet. Note that this option only pertains to variable and case merging and is only enabled if the Create new spreadsheet check box is selected.

File 1 variables. Select this check box to allow selecting only specific variables from File 1 to be copied to the output spreadsheet. After selecting this check box, click the Select button beneath it to select the variables from File 1 that you want to include in the output spreadsheet. Note that if the Create new spreadsheet check box is not selected, the unselected columns will be deleted from File 1.

File 2 variables. Select this check box to allow selecting only specific variables from File 2 to be copied to the output spreadsheet. After selecting this check box, click the Select button beneath it to select the variables from File 2 that you want to include in the output spreadsheet.

Preserve input order in output. Select this option to keep the ordering of the data in the output spreadsheet intact. This is to say, the output will not be sorted by any of the sort keys.

Settings.

Load. Click the Load button to display the Load Merge Settings dialog box to load a configuration file that keeps track of previously saved settings.

Save. Click the Save button to display the Save Merge Settings dialog box to save the current merge choices in a configuration file.