Merging Tables Together

Home   Back   Next  

Performing Standard Data Operations > Merging and Dividing Tables > Merging Tables Together


Strata provides you a simple tool for combining multiple tables together into a single table.



Rules for Merging


To merge tables together accurately, you need to have the same field names, same field structure and correct order of precedence.


Field Names: All fields you wish to merge must share the same names in each table.
Field Structure: All fields to be merged must have the same field structure.
Order: Tables have precedence based upon their order in the Tables to Merge list. The first table listed will be the first part of the merged file, the second table in the list will be the second part of the merged file, etc.


NOTE: If the first table has fewer fields than following tables, the only fields that will appear in the output file will be those from the first table. Choose table order with caution before merging.



Using the Merge Tables Functionality


To Merge tables, do the following:


1. Select "Merge Tables" from the Tools menu and the Merge dialog will open.


2. In the project panel, click on the table you wish to merge and drag it into the Merge dialog.  If you wish to remove a table from the merge dialog, simply select it and either drag it out of the dialog or click the Delete key.


3. Add an output table name either by just entering in the name and path manually or by clicking the Browse button and choosing a destination table.


4. Once all the criteria are completed, click the OK button.





Below is an example of how to merge two tables, "Merge1" and "Merge2" as shows below.





In this scenario, the table "Merge1" and "Merge2" both share the same field structure.  However, they have different field names as well as different data.  The above example gives table "Merge1" the order of precedence and, along with it, the fields chosen to appear in the output table.


If we instead gave "Merge2" precedence over "Merge1", the opposite situation would occur.  The screenshot below shows the results of these two scenarios ("Merge_combo" is the result of the "Merge1" having precedence and "Merge_combo2" is the result of "Merge2" having precedence):




Since both tables shared "Field1" and "Field2", these fields were merged for both outputs. However, since "Field3" and "Field4" were not shared, they only appear in the output where the originating table had precedence.