I'm currently trying to link (not sure if this is the best term) two data tables.
dt1 is raw data (multiple levels of a control with concentration values) *see example below*
dt2 is spec limits (multiple levels of spec limits, Alert and Customer) *see example below*
Ideally, I'd like to open dt1, then open dt2, and have those values set as Table Variables.
This is an example of the Low Control.
I'd update the titles to Low_C_LSL (Low Customer LSL), Low_A_LSL (Low Alert LSL), Med_C_LSL, etc. so that it would be clear. since there would be 15 table variables.
Once the Table Variables are set, I'll be using them for the Inverse Prediction model.
I've thought about splitting out the Low, Medium, and High, but since we have 13 products with three levels, and do most of our initial spreadsheet set up in Excel, going from one sheet per product to three would be tedious and confusing.
I've looked at so many other discussions and the scripting index, but not finding exactly what I need.
I currently have this jsl written, but instead of having 13 scripts for 13 products, I'd like to have one script and import the specs.
It basically just opens the Limits Table, but does nothing with it.
Names Default To Here( 1 );
path = Pick File( "Select Data Table" );
dt = Open( path );
path = Pick File( "Select Limits Table" );
dt2 = Open( path );
Current Data Table( dt );
dt << Set Table Variable( "Low Customer LSL", 15 );
dt << Set Table Variable( "Low Alert LSL", 20 );
dt << Set Table Variable( "Low Target", 40 );
dt << Set Table Variable( "Low Alert USL", 60 );
dt << Set Table Variable( "Low Customer USL", 65 );