cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
JBEng
Level I

Extracting Deltas between two tables serialized samples for multiple parametric measurements

I have measured data for 50 serialized parts over three different temperature (Room, Hot, Cold) in three different tables.  Each serialized part has over 100 measured parameters.  I want to extract the deltas (Room - Hot) and (Room - Cold).  Putting these two calculations into two new tables would allow me to find the parts with the worst temperature deltas.

 

i have tried Table compare, but it does not output the deltas.

 

I am using JMP17

3 REPLIES 3
jthi
Super User

Re: Extracting Deltas between two tables serialized samples for multiple parametric measurements

Stack your tables, join then together, perform the calculations and split the data gain to get the final delta columns

-Jarmo
JBEng
Level I

Re: Extracting Deltas between two tables serialized samples for multiple parametric measurements

I was reading about stacking tables this morning and it appears that it would create additional columns in my already large tables.  Is there another way?

jthi
Super User

Re: Extracting Deltas between two tables serialized samples for multiple parametric measurements

How familiar are you with JSL?

-Jarmo