topic Re: error in set col value with JSL formula in Discussions

error in set col value with JSL formula

ScatterChart190 — Fri, 09 Jun 2023 16:58:27 GMT

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 ("total", numeric, continious);
:total<<formula(:F+:M);// this line works by itself but causes error in script

:total<<formula(:F+:M);// this line works by itself after the script but causes error in the script?

Re: error in set col value with JSL formula

ErraticAttack — Thu, 05 May 2022 21:01:55 GMT

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 ("total", numeric, continious);
dt:total<<formula(:F+:M);// this line works by itself but causes error in script

Re: error in set col value with JSL formula

ScatterChart190 — Fri, 06 May 2022 00:04:54 GMT

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