484568_en-US

liliconcom

error in set col value with JSL formula

Open( "$SAMPLE_DATA/Big Class.jmp" ); 
dt=(Data Table( "Big Class" ) << Tabulate(
 Add Table(
  Column Table( Grouping Columns( :sex ) ),
  Row Table( Analysis Columns( :height ), Statistics( Mean ) )
 )
)) << Make Into Data Table;
dt<<NEW column=""></NEW>

:total<<FORMULA></FORMULA>

ScriptingRe: error in set col value with JSL formula

I personally try to avoid any auto-scoping in JSL, especially when it comes to column names.  If you explicitly scope :TOTAL to DT:TOTAL then this works.  The reason for the failure is because dt is not the current data table, and the current data table does not have a :TOTAL column.

 

Open( "$SAMPLE_DATA/Big Class.jmp" ); 
dt=(Data Table( "Big Class" ) << Tabulate(
 Add Table(
  Column Table( Grouping Columns( :sex ) ),
  Row Table( Analysis Columns( :height ), Statistics( Mean ) )
 )
)) << Make Into Data Table;
dt<<NEW column=""></NEW>

 

Re: error in set col value with JSL formula

Thanks, and it also explains why the last line "magically" works, when I switch to the tabulate table