nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Update or Match columns from 2 tables

vishwasanj

Hi All,

I have 2 data tables, data.jmp and final.jmp

I need to match 2 columns (lot name, wafer number) from data.jmp to 2 columns (LOT, WFR) from final.jmp. I need to create a new subset comparing these 2 tables and output as FINAL_UPDATED data table.

Thank you for the help.

Accepted answers

txnelson

What I specified in my last response is exactly what you need to do to put the 2 data tables together, matching upon the 2 pairs of columns you indicated. Below is the filled out dialog box from

Tables==>Join

that when executed creates the output table you described. Attached is the new table created.

Final_Update.jmp

All comments

txnelson

Use the pull down menu item

Tables==>Join

and you will be able to match the columns you need to match and it will generate a new data table

vishwasanj

Thank you txnelson. Maybe I should have explained this more clearly.

Attached are the tables.

data. jmp represents the user input file through .json

Final_table is the final concatenated table.

I want to refine the Final_table according to what I have in the data.jmp table.

Now I want to make a new table Final_Updated by matching LotInfoes.LotName and LotInfoes.Wafers of data.jmp to Lot and wafers of Final_table.jmp (For example, I don't have wafer 1 in the both lots, so my updated table shouldn't have it)

Any suggestions would help me.

data-2.jmp

Final_Table.jmp

txnelson

What I specified in my last response is exactly what you need to do to put the 2 data tables together, matching upon the 2 pairs of columns you indicated. Below is the filled out dialog box from

Tables==>Join

that when executed creates the output table you described. Attached is the new table created.

Final_Update.jmp

ian_jmp

In JMP 13 you might also find the virtual join useful.

vishwasanj

Thank you for the idea Ian

vishwasanj

Thank you txnelson