cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

Concatenating Data Tables

Started ‎06-10-2020 by
Modified ‎12-03-2021 by
View Fullscreen Exit Fullscreen

Learn more in our free online course:
Statistical Thinking for Industrial Problem Solving

In this video, you see how to concatenate two data tables.

 

The working file, with reject data over the previous four months of the year, is stored in Rejects Data.jmp.

 

You would like to add new data, stored in Rejects Data New.jmp, to your original data table.

 

Because the two files have the same structure and the same variable names, you can concatenate the two data tables.

 

To do this, we open both files and select Concatenate from the Tables menu.

 

We’ll concatenate Rejects Data, which is the active file, and Rejects Data New.

 

You can append the new data to the bottom of your original table, or you can create a new data table with the information from both time periods.

 

We’ll create a new data table named Rejects Data All.jmp.

 

Let’s look at the other options.

 

If we select Create source column, a new column with the two file names is added to the concatenated data table. This is useful if you want to double-check that the tables were correctly concatenated, or if you want to maintain a history of the source of the data.

 

Another option is Save and evaluate formulas. This is useful if you have formula columns in your data tables.

 

We’ll leave these two boxes unselected and click OK.

 

The final file, Rejects Data All.jmp, now has the original data, with the new data concatenated at the bottom.