Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Re: Access jsl code of New Column with Formula

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2019 1:16 AM
(294 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted
Solution

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

```
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);
```

2 REPLIES 2

Highlighted
Solution

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

```
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);
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Access jsl code of New Column with Formula

Thank you very much - works perfect