The Concatenate Table command allows the user to concatenate multiple tables into one. This is different than the merge command, as Concatenate just appends the second table to the first table by row (requiring the column names to be the same), while merge will merge row names and column names and sort the tables. It can be accessed by going to: Table | Concatenate.
Input Data Requirements
This command works on all “Table” objects, except for Design Tables and Annotation Tables, which have fixed rows.
Step 1: Select the tables to concatenate
The Concatenate Table menu option opens the "Concatenate Tables" window and automatically loads the table opened and viewed in ArrayStudio. Users can pick any number of additional tables to concatenate by clicking on the + button.
Step 2: Define the concatenate options
The options defined in this step determines how these tables will be concatenated.
- Remove duplicate names: Removes duplicated row names
- Index row name: If this option is selected, duplicated row names won't be deleted, just append to the first table
- Check column names: Check that column names match when appending. Un-checking this option will allow appending of rows even if the columns names are not matched.
- Append to the first table: Instead of creating a new table, add the data to the first table
- Create a source column: Add a column that indicates which table the row came from
- Output table name - The user can specify new table’s output name
A new table will be created in the Solution Explorer, concatenating the tables as defined in Step 2. Please refer to Example Usage for a specific case.
In the example below, there are 3 tables:
Concatenating table 1 and 2 (which have the same column names) will produce the following table:
Concatenating table 2 and 3 (which have different column names) will produce the following table. This works only if the "Check column name" option is unselected since they are different. Note that it is using the column names from the first table in the list. Merging these two tables instead of concatenating might be a better option.
Concatenating table 1 and 3 (which have different column names but the same row ID's) will produce the following table. This works only if the "Check column name" option is unselected since they are different. Note that it is using the column names from the first table in the list and the values from the second table in the list. NOTE: Since this is not likely to be the desired outcome, merging might be a better option: