JMP User Community

Latest Discussions

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

2232 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

1720 views | 2 replies
What makes the formula evaluate over and over?

I noticed an unexpected behavior in Jmp:After creating a Formula column with a Custom Formula, another Formula Column gets evaluated every time I select a cell in the data table.Why is the formula evaluated so many times? removing the myX =1; myX fro the first formula stops the behaviorremoving the custom formula from the second formula stops the behavior Jmp 17.2 Names Default To Here( 1 ); row...
hogi

Discussions |
Jan 24, 2024 8:51 AM

3596 views | 8 replies
Can JSL be used to automate plotting of charts and adding of ref lines among others

Hi, I plot Distribution charts on a regular basis. Some days I get just a few columns of data, some days quite a bit more. Once the individual charts are generated, I will need to adjust their respective min/max Y axis for readability, and then add in a couple of reference lines (basically USL and LSL lines). After a while, it gets tedious, especially there are a lot of columns of data. I would ...
BooBee

Discussions |
Jan 24, 2024 6:48 AM

5133 views | 12 replies
Hide columns script

I tried this script to hide column no.1,2,3 but it only select the columns without hiding them. What did i missed?Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); c= dt << Select Columns( [1.2.3] ); c << Hide;
Tavuk89

Discussions |
Jan 24, 2024 1:51 AM

2367 views | 3 replies

Previous
Next

Latest Discussions

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

2232 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

1720 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

1031 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

4656 views | 7 replies
For Each Loop across multiple associative arrays

Hi, I'm struggling with the syntax for a For Each loop across multiple associative arrays. For example:q = ["q1"=>11, "q2"=>22, "q3"=>33]; w = ["w1"=>1111, "w2"=>2222, "w3"=>3333];For single array, just for reference:For Each( {a, i}, q, Show( i, a ) ); // retrieves indices and keys For Each( { {a, b}, i }, q, Show( i, a, b ) ); // retrieves indices, keys and valuesAnalogously, across two arrays i...
AlterEgo

Discussions |
Jan 22, 2024 11:08 AM

1808 views | 2 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

749 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

1229 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

839 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

1136 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

925 views | 0 replies