Link between several mixture design

[#1]

Good morning,

Is it possible for JMP to link multiple data tables? For example, if we create several mixture designs with several raw materials where the response is viscosity. Can JMP connect two mixture designs and estimate the viscosity of a mixture containing one raw material from design 1 and another from design 2? If it is possible which is the best way to proceed? 

Many thanks for your response

[#2 · Accepted solution]

Hi @SquaresJackal10,

I'm not sure to have fully understood your question, but I would answer no if you don't have values in common between the two tables.

You can Virtually Join Data Tables if you have two tables that have an ID in common, but if your two tables represent different mixture designs with different raw materials, there would be nothing in common.

Also any join (virtual or not) will not create a mean estimation of a response, it can only display values/model predictions from one of the table by default.

I used virtual join in Use of Functional Data Explorer in a Mixture Design for Tribological Performance Prediction in order to visualize predictions from FDE (trained from the functional datatable) for any points in my mixture design (created in my DoE datatable). In this case, each experiment had an ID that I could use for link, even if the number of rows is different between the two tables.

Hope I did understand your question and that my response makes sense,

[#3]

It really helps us if you can attach the data tables in question.  Without knowing the specifics, it's hard to comment.