column name problem

mikedriscoll

I have a problem in my script where JMP is not recognizing the following syntax. It works fine when I run it with the script open and hit ctrl+R or right click and run script. But if I attach the script to an addin and run from a custom menu, for some reason it is not evaluating the "column name()" correctly and I can't think of a work around. Any work-around ideas?
Thanks.

joinDt << New Column( "Failures",
Numeric,
Continuous,
Formula( Eval( Column Name( 3 ) ) + eval( Column Name( 5 )) ),
Eval Forumula );

mikedriscoll

A little more detail on this: Both methods of running the script produce a data table output that are nearly identical. Running with script open and hitting ctrl+R puts the eval(column name (x)) in the formula box and it evaluates correctly.

Running the script from an addin menu produces an almost identical data table with the same formula (even if I copy / paste the formula from the output table of the script that ran correctly into the one that did not, and hit apply / ok!) but i end up with missing values.

I've seen this problem with another script, here's a snippet:
For( i = 1, i <= n, i++,
Current Data Table( limits );
If( !Excluded( Row State( i ) ),
col_name = Column Name( 1 )[/*###*/i];
...
)


Error msg:

object not subscriptable in access or evaluation of 'Subscript' , Column Name( 1 )

Running JMP9. i is a valid value here, the problem seems to be how it's handling the column name ().

Sorry, posting problems... here's the part of the code that counts:

col_name = Column Name( 1 )[/*###*/i];



Error msg:

object not subscriptable in access or evaluation of 'Subscript' , Column Name( 1 )

Running JMP9. i is a valid value here, the problem seems to be how it's handling the column name ().

Message was edited by: mjdeez