Append interactive mode – Pitney Bowes MapMarker USA User Manual
Page 299
Appendix D:
Append
MapMarker USA 25
299
User Guide
5. Choose a processing mode. Select Use Interactive Mode to choose individual groups of tables
to append. The tables are placed in a queue for Append to concatenate. For more information on
Interactive Mode, see
.
If you want the Append program to use a text file to determine which tables to append and how
to append them, select the Use Input File Mode check box. For more information on Input File
Mode see
.
6. Click OK in the Append Tables dialog to start processing.
While Append runs, the program appends tables and writes out the new appended table with
or without the table ID field, depending on the options you have chosen. When the program
finishes, Append records a summary of the results in the message file and a dialog is
displayed showing the elapsed processing time. You may open the message files in any text
editor such as Notepad.
7. When you have finished, select DataKit > Append > Exit Append to close the program. If the
Append command is the last item left in the DataKit menu, exiting the program also removes the
DataKit menu.
Append Interactive Mode
Interactive Mode allows you to specify each process one at a time. This allows you to build an
interactive list of tables that Append processes. Follow these guidelines to use Append in interactive
mode. Follow these steps for each group of tables you wish to append.
1. Click on the tables you want to select in the Table Names list. You can change the directory and
drive to display other tables. Keep the following in mind when choosing your tables:
•
Append does not let you concatenate tables if the numbers of columns in all of the tables are
not the same. The program returns you to the Append Tables dialog if you attempt to do this.
•
If the number of columns in all of the tables is the same but they do not share the same data
types between column numbers, Append tries to resolve the differences in the column types.
When this happens, Append may change some of the data types of your columns. If there
are changes, Append records these changes in the message file. If Append cannot resolve
the data type differences, the program returns you to the Append Tables dialog.
•
If the number and types of columns in the appended tables are the same but the names are
different, Append names the resulting columns according to the following rules. If you are
appending tables to an existing table, the column names of the existing table does not
change. If you are creating a new table with Append, the table has the same name as the first
table that you selected in the Table Names list.
2. To insert a table identifier field into the output table, select the Insert Table ID field check box.
The table identifier field contains the source table name for each row.
3. Click on Add to List. Append prompts you for the output name of the appended table. Enter the
table name and click OK.
4. Click on View/Save List to inspect or save the current interactive list. You may want to do this if
you intend to process the same tables later in Input File Mode. To remove all the items in the
current interactive list, click Clear List.