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.
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.