Subscribe Bookmark RSS Feed

Concatenating table rows with different column names

NME

New Contributor

Joined:

Sep 28, 2017

I'm trying to concatenate two data tables, one right under the other.  One of the tables is a continuation of the other table, but it doesn't contain column labels.  JMP 12 Help tells me that "if the two original data tables have columns with different names, those columns are included in the new data table showing missing values" when using Tables>Concatenate.  And this command definitely behaves this way (I've tried to get around this for a while with no luck)...

 

How CAN I force JMP to append my rows from one table to the bottom of another table?  Changing the column names is not an option, since I'm working with ~500 columns.

 

Any advice would be greatly appreciated.  I am fairly new to JMP, but scripting may be an option, if I'm helped along the way...

1 ACCEPTED SOLUTION

Accepted Solutions
julian

Staff

Joined:

Jun 25, 2014

Solution

Hi @NME,

 

I also run into this issue occasionally, and the best solution I've found is copying the column names from one table to the other table, and then concatenating. JMP makes this very easy -- you can select the columns in the columns list, and copy, then select the columns in the columns list of the other table and paste. I've added a 1min video showing this below.

 

I hope this helps!

 

-julian

 

 

 

 

4 REPLIES
julian

Staff

Joined:

Jun 25, 2014

Solution

Hi @NME,

 

I also run into this issue occasionally, and the best solution I've found is copying the column names from one table to the other table, and then concatenating. JMP makes this very easy -- you can select the columns in the columns list, and copy, then select the columns in the columns list of the other table and paste. I've added a 1min video showing this below.

 

I hope this helps!

 

-julian

 

 

 

 

julian

Staff

Joined:

Jun 25, 2014

Alternatively, you can select all rows and columns in the second table, Edit > Copy, then click in the first table, and with nothing selected (no columns and no rows) select Edit > Paste. As long as there is the same number of columns (and the data types match) JMP will paste the rows without respect to column names. This is sometimes faster, but I personally prefer the copy/paste column names then concatenate method since I can toggle adding a "Source Column," which is often useful. 

 

-julian

 

NME

New Contributor

Joined:

Sep 28, 2017

This solution is just too easy, I couldn't think of it...!  Thanks for your help.

julian

Staff

Joined:

Jun 25, 2014

You're so welcome!