JMP User Community

Latest Discussions

How to Use a Variable for Custom Value Order in JMP Scripting?

Hi everyone, I'm trying to set a custom value order in a column using JSL. Here's the code that works when I hardcode the list: TestTable:Origin << Set Property( "Value Order", {Custom Order({"EU", "IND", "US", "JPN", "AU"}), Common Order(0)} ); However, when I try to pass the list as a variable, it doesn't work: countriesOrder = {"EU", "IND", "US", "JPN", "AU"}; TestTable:Origin << Set Proper...
mysteriouskrypt

Discussions |
Aug 28, 2025 2:57 PM

342 views | 1 replies
Path to long for Files in Directory() ?

I came across the following problem while trying to access some files: Due to some directory structures the path to the desired directory can be greater than 134 characters. If the path is 134 characters long or shorter, file in directory() has no problem of listing the files in the directory, but if its longer than 134 (same parent directory) the list is empty. I already checked my permissions an...
Erik_The_First

Discussions |
Aug 27, 2025 10:39 PM

1566 views | 9 replies
Obtenir un raccourci pour la commande "Exécuter à nouveau les formules"

Ce serait très pratique d'avoir quelque chose comme le F9 d'Excel, notamment pour les formules avec de l'aléatoire. Je n'ai pas trouvé le moyen de "coller" un raccourci à cette commande. Possible ? Par avance merci.
rugolf

Discussions |
Aug 27, 2025 11:15 AM

278 views | 1 replies
script - delete or reorder colums

hi, I would like to add "delete multiple columns" or "reorder multiple columns" to my script. How can I code this into my scripts? JMP help provides a simple description for a single column, but I can't do it manually for more than 100 columns. Thank you in advance A++ Zdenek dt = Open("$SAMPLE_DATA/Big Class.jmp"); dt:height << Set Selected; Wait(2); dt << Delete Columns(); Edit (jthi): ad...
cz1

Discussions |
Aug 27, 2025 12:39 AM

302 views | 1 replies
How do I get rows based on dynamic column selection in JSL

In a JMP script I would like to retrieve the rows matching a certain criteria specified by user. I would like to do something similar to this: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); r = dt << Get Rows Where( :sex == "M" ); Show( r ); Only where the criteria is selected by the user, i.e. the column ("sex") and the target value ("M") should be dynamic. I have tried ...
peter_t

Discussions |
Aug 26, 2025 2:25 AM

841 views | 1 replies

Previous
Next

Latest Discussions

Obtenir un raccourci pour la commande "Exécuter à nouveau les formules"

Ce serait très pratique d'avoir quelque chose comme le F9 d'Excel, notamment pour les formules avec de l'aléatoire. Je n'ai pas trouvé le moyen de "coller" un raccourci à cette commande. Possible ? Par avance merci.
rugolf

Discussions |
Aug 27, 2025 11:15 AM

278 views | 1 replies
script - delete or reorder colums

hi, I would like to add "delete multiple columns" or "reorder multiple columns" to my script. How can I code this into my scripts? JMP help provides a simple description for a single column, but I can't do it manually for more than 100 columns. Thank you in advance A++ Zdenek dt = Open("$SAMPLE_DATA/Big Class.jmp"); dt:height << Set Selected; Wait(2); dt << Delete Columns(); Edit (jthi): ad...
cz1

Discussions |
Aug 27, 2025 12:39 AM

302 views | 1 replies
create new column and set each row value from different column based on another column (column name variable)

Hi, I have data similar to example in picture. first 6 columns are related. I created MaxCol to find out who has the Max which based on first 3 columns, then I want to create MaxValFromCol column where it take value from one of the column from 4-6. it will pick value from column 4-6 based on MaxCol. I tried to set the value of MaxValFromCol using Column(char(:MaxCol) || "_t"), but not success. ...
dadawasozo

Discussions |
Aug 25, 2025 9:31 PM

1305 views | 5 replies
How to separate excel "copy paste" in JMP string?

Hey, so by copy pasting some cells from excel into a JMP data table column, the cells are perfectly split into separate rows. But if I paste the same cells into a text edit box or just in a JSL script, the cells are only separated by a "pseudo" line break. They all are in different rows but don't have a whitespace or line break or other delimiter in between. How can I separate them like JMP does i...
Erik_The_First

Discussions |
Aug 25, 2025 12:13 AM

938 views | 3 replies
Disallowed combinations

Hello, I have a factor with three levels and I am trying to create a design in which this factor levels are not equal in any given block. So for instance, Factor A should not have the same level repeated in any block. How can I do this please? Thanks.
aus22

Discussions |
Aug 20, 2025 1:53 PM

1649 views | 6 replies

Previous
Next

Latest Discussions

How to export a model formula to Excel?

I want to be able to take the prediction formula that I got from my multiple linear regression and put it in excel. I have multiple Quantitative and Categorical X variables and some are splined. I have also preformed a BoxCox transformation. What are the steps that I need to do to take the formula that is given and have it working in excel. I have no coding experience but am not against learning a...
DWS

Discussions |
Jun 13, 2025 8:33 AM

517 views | 0 replies
Inquiry Regarding the Use of JMP and JMP Live (Suppress Eval?)

Hello, I am a user of JMP Live.
I am currently utilizing a simple function within JMP to leverage the Auto Refresh feature in JMP Live for dashboard purposes. However, while the function operates correctly on my PC, it does not work properly on JMP Live.Even though I have disabled "Suppress Eval" before executing Data Publish, when I later download the data, the column where the function should be ...
DJ_Kim

Discussions |
Feb 27, 2025 2:59 PM

553 views | 0 replies
Streamlining Data Workflows With JMP & MATLAB

Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...
brycerjs8

Discussions |
Feb 18, 2025 7:07 AM

578 views | 0 replies
How to adjust the size of R plot imported with get R graphics(); ?

I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want? R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...
CountableModel1

Discussions |
Jan 15, 2025 4:01 PM

612 views | 0 replies
Exceptions are the utilities Show, Write, and Print ...

from: https://www.jmp.com/support/help/en/18.1/?os=win&source=application#page/jmp/advanced-expressions-macros-and-lists.shtml# If you assign the expression x+y to a, quoting it as an expression with Expr, then whenever a is evaluated, it evaluates the expression using the current values of x and y and returns the result.
Exceptions are the utilities Show, Write, and Print, which do not evaluate e...
hogi

Discussions |
Jan 7, 2025 10:44 PM

607 views | 0 replies