Using JMP > Reshape Your Data > Concatenate Data Tables > Example of Concatenating Data Tables and Table Variables
Publication date: 03/23/2021

Example of Concatenating Data Tables and Table Variables

For example, suppose that two cancer trials were conducted at two different hospitals. One of the trials’ data is in the data table, and the other trial’s data is in the data table.

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

1. Select Help > Sample Data Library and open and

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 data table, select Tables > Concatenate.

3. Select Cancer2 and click Add.

4. Click OK.

Figure 6.21 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 (