Control Chart Limits sourced from table columns

[#1]

hello- I am trying to help a friend with an SPC/ Data flow question and we aren't sure how to proceed.  This may involve scripting.

We are able to source process monitoring data from our Plant ERP system and get it into JMP (V19).  

Control Limits have already been established and are extracted along with the data from the plant system.  The constant limits repeat each row.

How could we use these columns to be used as limits for a control chart?  We would prefer not to use a JMP saved lookup table, or column properties to save the limits- the plant data source should remain as the "master".

For example: assume attribute Length with LCL=15.88, and UCL=16.11

The incoming data will look like this:

Length	Lower_Lim	Upper_Lim
16.01	15.88	16.11
15.98	15.88	16.11
16.03	15.88	16.11
15.99	15.88	16.11

 Thanks

Stuart

[#2 · Accepted solution]

You could run this line on your table.

Eval( Eval Expr( :Length << Set Property( "Control Limits", {XBar( LCL( Expr( :Lower_Lim[1] ) ), UCL( Expr( :Upper_Lim[1] ) ) )} ) ) );

  Note you have to include the Control Chart type, such as "XBar," for this to have any effect.

[#3]

Thanks mmarchland for the speedy reply!
That is much shorter than anything I had considered.  I will approach it using the EVAL concept... 
-Stu