When you concatenate data tables in JMP, you combine rows from two or more data tables. You can create a new data table or you can append rows to the first data table. If a column name is the same in the data tables that you want to concatenate, then the column in the new data table lists the values from all of the data tables in the order of concatenation. If the two original data tables have columns with different names, those columns are included in the new data table showing missing values.
1.
|
Select Tables > Concatenate.
|
3.
|
(Optional) Click the Save and evaluate formulas choice to request that JMP include all formulas.
|
4.
|
(Optional) Click the Create source column choice to add a column called Source Table to the new data table.
|
5.
|
(Optional) Select the Append to first table choice to append rows to the data table listed first in the Data Tables to be Concatenated field instead of creating a new data table.
|
6.
|
(Optional) Type a name for the new data table in the Output table name field.
|
If you do not type a name, JMP names the data table Untitled# (for example, Untitled1). The Output table name field is not available if you selected the Append to first table choice.
7.
|
Click OK.
|
1.
|
2.
|
3.
|
4.
|
Click OK.
|
The data tables combine into a new concatenated table with all of the rows from the first data table followed by all of the rows from the second data table. See Result of Concatenating Two Data Tables.
Concatenated data tables always have a column for every column name found in the original data tables. However, if the column names do not match exactly, they are not merged. For example, if the yield column was instead named yield1 and yield2, a separate column would be created for each in the concatenated data table.
For example, suppose that two cancer trials were conducted at two different hospitals. One of the trials’ data is in the Cancer1.jmp data table, and the other trial’s data is in the Cancer2.jmp data table.
1.
|
Notice that there are two distinct table variables: Dosage Amount and Location. In the concatenated table, columns will be created for these two table variables.
2.
|
3.
|
4.
|
Click OK.
|