JMP User Community

Latest Discussions

Error in running script - Send Expects Scriptable Object in access or evaluation of 'Send' , dt << /*###*/get column names( string, continuous ) /*###*/

I have modified the script shared earlier by one of the contributors (thank you) so that the user can choose which data file (.jmp) file to open: Names Default To Here( 1 ); // Open a dialog to choose a .jmp file to open // Get the filename of the .jmp file to open dt = Pick File("Select a .jmp file to open", "", {"JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, ""); // If the user did not select...
BooBee

Discussions |
Jan 26, 2024 4:59 AM

5795 views | 11 replies
script

Bonjour à tous, Dans une base de données, je cherche à retrouver une valeur dans une colonne et garder en mémoire l’indice de la ligne dans une variable. Ensuite, avec cet indice, je fais des modifications sur une autre colonne. Mon script fonctionne quand je l’intègre dans la base de données mais pas quand je créé un script indépendant.Voici la table et la script que j’utilise : Names Default To ...
hcarr01

Discussions |
Jan 26, 2024 1:47 AM

968 views | 1 replies
How to get non-empty row values corresponding to chosen labels from columns?

I have incoming data of the form as attached.I want to get the first first three row values from each column (encircled red) which appear against specific labels (encircled blue).The following works for Current but not for Voltage (for Voltage I get empty values which I understand why)Stage = "7"; resCol = "Current"; theLSL = Column( dt, resCol )[(dt << get rows where( :TestStage == Stage & :lab...
Neo

Discussions |
Jan 25, 2024 8:22 PM

3384 views | 8 replies
Run Query in background

Hi, Is it possible to add <<Run background to "Execute SQL( ODBC, SQL, "table" )"?I am aware that it works with "New SQL query", not sure if works with Execute sql.
Jackie_

Discussions |
Jan 25, 2024 5:56 AM

2224 views | 5 replies
JSL Summary function (is this really the expected behaviour?)

Hi everyone, I use JMP on several computers and on one of them, I had installed JMP with the interface in French while on other it is in English. Both run under MacOS. This normally doesn't prevent me from running JSL scripts on either without having to modify anything. However, I came across a situation where it makes the code fail. In the summary function , one can ask for the column names in th...
yvesprairie

Discussions |
Jan 25, 2024 12:56 AM

1715 views | 2 replies

Previous
Next

Latest Discussions

script

Bonjour à tous, Dans une base de données, je cherche à retrouver une valeur dans une colonne et garder en mémoire l’indice de la ligne dans une variable. Ensuite, avec cet indice, je fais des modifications sur une autre colonne. Mon script fonctionne quand je l’intègre dans la base de données mais pas quand je créé un script indépendant.Voici la table et la script que j’utilise : Names Default To ...
hcarr01

Discussions |
Jan 26, 2024 1:47 AM

968 views | 1 replies
Run Query in background

Hi, Is it possible to add <<Run background to "Execute SQL( ODBC, SQL, "table" )"?I am aware that it works with "New SQL query", not sure if works with Execute sql.
Jackie_

Discussions |
Jan 25, 2024 5:56 AM

2224 views | 5 replies
JSL Summary function (is this really the expected behaviour?)

Hi everyone, I use JMP on several computers and on one of them, I had installed JMP with the interface in French while on other it is in English. Both run under MacOS. This normally doesn't prevent me from running JSL scripts on either without having to modify anything. However, I came across a situation where it makes the code fail. In the summary function , one can ask for the column names in th...
yvesprairie

Discussions |
Jan 25, 2024 12:56 AM

1715 views | 2 replies
Combine multiple "Save Script to Journal" into one journal

Hi all, I am trying to do "save script to journal" with two different plots, it is appending on the journal, the problem is I cannot save the journal itself. Also, in my graph builder plot, why is it prompting to save the file? Please help Sample script:biv = dt << Bivariate( invisible, Y( :height ), X( :weight ), By( :sex ) ); biv << Save Script to Journal; //1st gb = dt << Graph Builder( Varia...
UserID16644

Discussions |
Jan 23, 2024 4:18 AM

1028 views | 1 replies
Setting Spec Limits with USL=LSL?

Hi. I have a data table column consisting of coded integer values. For example, a "0" indicates "OK", and other numbers indicate some kind of issue. I would like to set spec limits of (0,0) for this column, but JMP issues a "Consistency Error" when I try this and will not let me have the USL be less than or equal to the LSL. I know I could just set the limits to be something like (-0.1, +0.1),...
nikles

Discussions |
Jan 22, 2024 5:27 PM

4646 views | 7 replies

Previous
Next

Latest Discussions

GraphBuilder Legend hook

There are many useful instances of being able to have a hook onto the selection state change of a legend for a chart / graph. With the non graph-builder method of generating charts' and graphs' legends (using Row Legend()), this was quite simple as the display element was simply a Table Box() that can receive a Set Row Change Function() message. The same cannot be done (to my knowledge) with Gra...
ErraticAttack

Discussions |
Jan 17, 2024 6:41 PM

747 views | 0 replies
Copy Columns - selected rows

Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s) - with all the settings ... and paste it into a JSL script - or another table. There is a hidden feature:
When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column. So, when you select all rows before...
hogi

Discussions |
Jan 3, 2024 1:27 PM

1228 views | 0 replies
Documentation for Promise/async http requests

Hi, I was wondering if anyone knows of any documentation for Promise objects. So far I am finding fairly little in the scripting index or at https://www.jmp.com/support/help/en/17.2/index.shtml. I am currently working from the Send documentation, which gives an example and demonstrates that you can use `<< On Response` and `<< On Error`, but not what else, if anything you can do with a Promise obj...
mat-ski

Discussions |
Dec 22, 2023 9:45 AM

837 views | 0 replies
Keyboard shortcuts

[More Topic Containers like this] Jmp Help/Keyboard Shortcuts assign new Keyboard ShortcutsAssigning-keyboard-shortcuts-for-frequently-used-options comment/uncomment blocks of code (international keyboard)A shortcut can be set in the menu customization Editoradd keyboard shortcuts for your own functionsadd them to the main menu/ to a toolbar and assign a shortcutadd keyboard shortcuts for "open...
hogi

Discussions |
Nov 26, 2023 1:38 AM

1134 views | 0 replies
Could JMP optimize factors with uncertainty?

Hello community!!,A question: will it be possible for the profiler to find the best combinations of factors with uncertainty when performing a simulation, which maximize the total utility and minimize the total cost, generating a table of the best combinations found? For example:
Marco1

Discussions |
Nov 21, 2023 9:08 AM

920 views | 0 replies