- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Table formula
JMP has something called 'table variables'.
Similarly, how can I create a function linked to a table that can be used as part of a column formula?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Table formula
Referring to Table Variables is done in same way as referring to Columns
Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Table Variable("Days", "42");
dt << New Column("Age+Days", Numeric, Continuous, Formula(:Age + num(:Days)));
Also search Scripting Guide for Table Variable for more info such as:
Table Variables
Table variables are for storing a single text string value, such as "Notes".
It also has info on the name resolution ordering (if you have same name in column and table variable, column will be preferred over table variable)
Edit:
If you want to have functions which can be used in formulas, you can directly write them into the formulas, but I would suggest creating custom formulas:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Table formula
Referring to Table Variables is done in same way as referring to Columns
Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Table Variable("Days", "42");
dt << New Column("Age+Days", Numeric, Continuous, Formula(:Age + num(:Days)));
Also search Scripting Guide for Table Variable for more info such as:
Table Variables
Table variables are for storing a single text string value, such as "Notes".
It also has info on the name resolution ordering (if you have same name in column and table variable, column will be preferred over table variable)
Edit:
If you want to have functions which can be used in formulas, you can directly write them into the formulas, but I would suggest creating custom formulas: