cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Batista
Level II

how to use join, update and concatenate

Hi need more information when to use this tools:  join, update and concatenate.

Witch one shoul i use to combine to two table that have same column names  but different ID patients? How to add all the patients and make one table?

 

Another question is how to update a table with new data?

1 ACCEPTED SOLUTION

Accepted Solutions
markschahl
Level V

Re: how to use join, update and concatenate

Batista:

 

Help > Tutorials has two Join and one Stack tutorials.

There are a few videos on JMP's YouTube Channel:

 

 

 

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: how to use join, update and concatenate

This is all covered in the Documentation...….Using JMP
Help==>Books==>Using JMP
Jim
markschahl
Level V

Re: how to use join, update and concatenate

Batista:

 

Help > Tutorials has two Join and one Stack tutorials.

There are a few videos on JMP's YouTube Channel:

 

 

 

Jeff_Perkinson
Community Manager Community Manager

Re: how to use join, update and concatenate


@Batista wrote:

Witch one shoul i use to combine to two table that have same column names  but different ID patients? How to add all the patients and make one table?

Tables->Concatenate is what you need when you have two table with the same columns that you want in one table.

Another question is how to update a table with new data?

It depends on what you mean about updating. If you get another table with the same columns but new rows you can use Tables->Concatenate again. There's an option to Append to the first table. That will update the main table instead of creating a new table.

-Jeff