Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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
Article Labels

    There are no labels assigned to this post.