For a Merge operation, all input files and the output file must be the same shape. In other words, they must use the same schema.
To merge multiple files into one file
- Right-click the Merge/Split process and select Edit Process. The Options window opens.
- Select Merge or Both in the Process Type list box. If you select both, the utility runs the merge process first, then the split process.
- For Match key 1 - 5, select an attribute from the drop-down list.
- If you select Both in Step 2, select the Split Options tab and specify the split options.
- (Optional) Specify input settings and output settings.
- Click Finish.
- From the Navigation View, right click the Merge/Split process and select Run. The Execute Process window opens.
- Run the process now or schedule the process to run later.
Example
In this example, Input 1 is merged with Input 2 using the Name attribute as the Match Key.
Input 1
|
Column_ID# |
Name |
|---|---|
|
0000001 |
John Nicoli |
|
0000002 |
Mary Nicoli |
Input 2
|
Column_ID# |
Name |
|---|---|
|
9000001 |
Alice Rogers |
|
9000002 |
Kevin McCarthy |
On output, the program copies the Match Key values from Input 1 and Input 2 along with other components of data. The order of the record is determined by the order of the key values. As a result, the total number of records is the sum of the number of records from Input 1 and Input 2.
Output File
|
Column_ID# |
Name |
|---|---|
|
9000001 |
Alice Rogers |
|
0000001 |
John Nicoli |
|
9000002 |
Kevin McCarthy |
|
0000002 |
Mary Nicoli |