topic Re: how to use join, update and concatenate in Discussions

how to use join, update and concatenate

Batista — Mon, 19 Aug 2019 15:10:06 GMT

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?

Re: how to use join, update and concatenate

txnelson — Mon, 19 Aug 2019 15:43:01 GMT

This is all covered in the Documentation...….Using JMP
Help==>Books==>Using JMP

Re: how to use join, update and concatenate

markschahl — Wed, 21 Aug 2019 01:06:40 GMT

Batista:

Help > Tutorials has two Join and one Stack tutorials.

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

Re: how to use join, update and concatenate

Jeff_Perkinson — Wed, 21 Aug 2019 01:02:03 GMT

@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.