topic Extracting Deltas between two tables serialized samples for multiple parametric measurements in Discussions

Extracting Deltas between two tables serialized samples for multiple parametric measurements

JBEng — Thu, 26 Sep 2024 19:03:19 GMT

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

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

jthi — Thu, 26 Sep 2024 19:08:49 GMT

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

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

JBEng — Mon, 30 Sep 2024 11:16:37 GMT

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?

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

jthi — Mon, 30 Sep 2024 11:47:41 GMT

How familiar are you with JSL?