Merging Files - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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.

Note: Input files must be sorted by the match keys.

To merge multiple files into one file 

  1. Right-click the Merge/Split process and select Edit Process. The Options window opens.
  2. 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.
  3. For Match key 1 - 5, select an attribute from the drop-down list.
  4. If you select Both in Step 2, select the Split Options tab and specify the split options.
  5. (Optional) Specify input settings and output settings.
  6. Click Finish.
  7. From the Navigation View, right click the Merge/Split process and select Run. The Execute Process window opens.
  8. 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