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.
Concatenate Window
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.
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.
Suppose you want to concatenate two data tables (Trial1 and Trial2) into a new data table.
1.
Open the Trial1.jmp and Trial2.jmp sample data tables.
2.
From the Trial1.jmp table, select Tables > Concatenate.
3.
In the Opened Data Table list, select Trial2 and click Add.
4.
Result of Concatenating Two Data Tables
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.
Open the Cancer1.jmp and Cancer2.jmp sample data tables.
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.
From the Cancer1.jmp data table, select Tables > Concatenate.
3.
Select Cancer2 and click Add.
4.
Data and Variables Concatenated