Merging two tables using several columns

[#1]

Hello Commmunity,

I have two JMP tables where each row represents a person, including age, sex and area, but no unique ID.

Table 1 has columns: Age Sex Area and columns with info A B C

Table 1 has columns: Age Sex Area and columns with info X Y Z

I need a table where rows with A B C are added to those with X Y Z. 

Is it possible to merge the two based on rows with identical combos of Age Sex and Area? If so, how do I do this?

Thanks!

[#2]

Hi Maximillian,

Do you have JMP 13? If so, you can use Query Builder for Tables under the Tables menu. There you can specify several columns to be the keys to uniquely identify each person without a unique ID column. Then you can join in two tables as you like.

See this link:

http://www.jmp.com/support/help/13-2/JMP_Query_Builder.shtml

Hope that helps.

Chris Kirchberg

[#3]

Using Tables > Join you can use matching columns to join your tables.  For POC I used Bands Data.jmp from the sample data and subset a portion of the data out and then deleted the columns I wanted to add back from the original table.  See the set up dialog below as a guide on how to set up the join.  If you are joining more than two tables together then I would suggest using JMP Query Builder also found under the Tables drop down.