For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Reshape Your Data > Concatenate Data Tables > Example of Concatenating Data Tables and Table Variables
Publication date: 04/21/2023

Example of Concatenating Data Tables and Table Variables

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.

To consolidate the data and the variables into one JMP data table, follow these steps:

1. Select Help > Sample Data Folder and open Cancer1.jmp and Cancer2.jmp.

Notice that there are two distinct table variables: Dosage Amount and Location. In the concatenated table, columns are created for these two table variables.

2. From the Cancer1.jmp data table, select Tables > Concatenate.

3. Select Cancer2 and click Add.

4. Click OK.

Figure 6.19 Data and Variables Concatenated 

Data and Variables Concatenated

The data and the variables are concatenated. The variables appear as columns in the concatenated table. The notes from each data table are added to the new data table as table variables.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).