Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
mlo1
Level III

Access jsl code of New Column with Formula

Hello,

 

is there a simple way of getting the jsl code of a generated column (I used New Formula Column from column menu) as I am wondering how to deal with the local variables in the New Column jsl code (Formula).

Best regards

 

2019-02-26 10_06_23-Year Week[Timestamp] - JMP.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ian_jmp
Staff

Re: Access jsl code of New Column with Formula

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

// Add a formula column . . .
nc = dt << NewColumn("BMI", Numeric, Continuous, Formula((:weight/:height^2)*703));

// Get the formula expression from a column into a variable . . .
bmiFormula = nc << getFormula;
Print(bmiFormula);

View solution in original post

2 REPLIES 2
Highlighted
ian_jmp
Staff

Re: Access jsl code of New Column with Formula

NamesDefaultToHere(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

// Add a formula column . . .
nc = dt << NewColumn("BMI", Numeric, Continuous, Formula((:weight/:height^2)*703));

// Get the formula expression from a column into a variable . . .
bmiFormula = nc << getFormula;
Print(bmiFormula);

View solution in original post

Highlighted
mlo1
Level III

Re: Access jsl code of New Column with Formula

Thank you very much - works perfect
Article Labels

    There are no labels assigned to this post.