Append Multiple Files

Filename

The name of a file that is to be appended. You can type in the name of a file including its full path directly. Alternatively, you can browse for a file by clicking the

button. Files that are selected using the browse dialog will be added to the list of filenames automatically. However, if you type in the filename directly the Add button should be used to add the filename to the list of files that are to be appended. Multiple files can be selected using the browse dialog by selecting one or more files using the Ctrl or Shift keys. For multi-paged GenStat books (GWB) or Excel files, you will be prompted for each of these files in turn to select one or more of the sheets within the file to append. Note that if a GenStat book only contains one sheet no prompt will appear.

The files are appended in the order that they are displayed in the list, however, you can change the order of the files in the list using the Up, Down and Bottom buttons.

Add

Add the filename in the Filename field into the list of files.

Change

Replace the selected filename in the list with the name in the Filename field.

Remove

Remove the selected filename(s) from the list.

Up

Move the selected filename up once place in the list.

Down

Move the selected filename down once place in the list.

Bottom

Move the selected filename to the last place in the list.

Match columns by

Position	Data within column 1 will be appended to column 1, 2 to 2 etc.
Name	Data from columns with the same name will be appended to each other.

Add to Book

This lists all open books within GenStat. Select the book that the new sheet will be added to. If the data are to appear in a new book then select the New Book setting.

Check for Factors

When selected, GenStat checks all columns to see if they contain repeated values. If columns appear to contain categorical data you are prompted to convert these to factors.

Check for Dates

When selected, GenStat checks all text columns to see if they contain data in date format. If columns appear to contain data in date format you are prompted to convert these to dates.

Set as Active Sheet

This sets the new spreadsheet that is created as the Active spreadsheet. See Setting an Active Spreadsheet for more details.

Action Buttons

Open	Append the files and close the dialog.
Cancel	Close the dialog without further changes.

Example

The dialog shown below has been opened using the browse button

. It shows a number of GenStat Spreadsheet (GSH) files that have been selected to be appended into a single spreadsheet. Clicking Open on this dialog copies the file names into the file list, as shown below.

Clicking Open on the above dialog will open the files into a single spreadsheet. The files are appended in the spreadsheet in order they appear in the list. When selecting multiple files you can use the Up and Down buttons to rearrange the order that the files will be appended in.