JMP User Community

Latest Discussions

Replacing a blank row with another row data with an if statement

Hi, I have an original set of data (table1), and I am trying to script it to the result in table 2. If any number that is below 300, will print "type1" string into "result1" column. If any number is above 300, will print "type2" string into "result2" column. Numbertype1type2result1result2100a1a2 200b1b2 150c1c2 275d1d2 555e1e2 424f1f2 572g1g2 783h1h2 125i1i2 Table1: Original data N...
kuanaunwei

Discussions |
Jan 11, 2023 4:58 AM

1981 views | 3 replies
R integration, issue with R Submit File

Hi, Update: I found a workaround which I posted in the comments.This JSL script runs without any problems (I am using JMP 16.0.0 (512257) under Windows 10 Pro 64 bit) and generates the expected png output from ggplot in JMP:LoadExprs = Expr( InitR = Expr( R Init(); R Submit( " library(dplyr) library(ggplot2) library(palmerpenguins) " ); ); MakePlot = Expr( R Submit( Eva...
paul_vanoppen

Discussions |
Jan 10, 2023 5:11 PM

3060 views | 5 replies
how can I extract the names of scripts in a folder then execute them?

I am trying to extract the names of files in a subfolder and then extract them, So far I am using theFiles in directory() And getting a list and adding to a data table, but I am struggling to get from here to an executable jsl file that will run them all. Any assistance would be great thanks
AlanBell

Discussions |
Jan 6, 2023 8:24 AM

2778 views | 5 replies
With JSL, how to split a datatable by distinct values in a column?

Hello, I'm a starter of JSL and I have a question :grinning_face:For example, I have a data table, and I want to divide (subset) it into several data tables, by the values of B column. A B C A B C A B C 1 1 1 => 1 1 1 AND 3 2 6 2 1 4 2 1 4 2 2 1 3 2 6 5 2 3 2 2 1 5 2 3 I know how to Subset a data table, or how to sele...
Setsuna

Discussions |
Jan 6, 2023 6:00 AM

1802 views | 2 replies
For Each() syntax

Hello, I'm looking to expand the number of values that can be used in the For Each() function. In the scripting index and handful of examples I've found within JMP community and JMP itself, combined, I've only seen a single value and index used: For each( { val1, index}, ... ). I'd like to use: For each( { val1, val2, ..., valn, index}, ...) . When I increase the number of values in the curly bra...
StarfruitBob

Discussions |
Jan 5, 2023 2:39 PM

7032 views | 11 replies

Previous
Next

Latest Discussions

For Each() syntax

Hello, I'm looking to expand the number of values that can be used in the For Each() function. In the scripting index and handful of examples I've found within JMP community and JMP itself, combined, I've only seen a single value and index used: For each( { val1, index}, ... ). I'd like to use: For each( { val1, val2, ..., valn, index}, ...) . When I increase the number of values in the curly bra...
StarfruitBob

Discussions |
Jan 5, 2023 2:39 PM

7032 views | 11 replies
Jmp script to get variability charts with common x-grouping

Hi,I am a bit new to jmp, so bare with me. I was looking to graph variability plots that plot the same y-variable and same x-grouping but separated by different variables in the 'By' section. For example, how do I get the plot that looks like the one on the left and not the one on the right (that it produces by default). Is there a JSL script to do such a thing?

FrequencyBison9

Discussions |
Dec 22, 2022 5:21 PM

1574 views | 1 replies
email invite and sharepoint compatibility

I had a few jsl questions.Can jsl code be written to send a meeting invite for outlook?Can a link be set up on sharepoint to automatically run a script when the link is clicked? (without prompting and downloading the script first?)If I integrated to the two questions you will get the full pictureUser clicks the sharepoint link which runs the script Window opens to enter email addressesUser types i...
Derek11

Discussions |
Dec 21, 2022 12:55 PM

1357 views | 1 replies
JMP12 initialization to R

Yes, it was not a typo. I am still using my revered copy of JMP12. I am trying to connect to R ver. 4.1.3. After executing the R Init() command from the scripting index I received the error that R was not installed. After changing my windows 11 environment variable for R_HOME to the directory where R was installed this error disappeared and another took its place. I am now getting this error "...
floydfoxfb

Discussions |
Dec 21, 2022 8:13 AM

1093 views | 1 replies
What's the deal with leading underscores precisely?

I realize (yet again) that this is a noob question, but I don't find it adequately answered in the Scripting Index. As regards the use of two leading underscores, the Scripting Index is clear: To hide (or protect) a global variable, put two underscores (__) before the name. (Also something explained by Mauro Gerber during the last Scripter's Club session.)When it comes to single leading underscore...
Ressel

Discussions |
Dec 18, 2022 8:08 AM

1655 views | 1 replies

Previous
Next

Latest Discussions

C Stack Usage Error When Sending Code to R

Hello, I'm trying to invoke some commands in R using the R Submit function in JSL and am getting the error below. Is this an issue with JMP17 and R integration? It only happens when I invoke a specific package using JSL so it's hard for others to replicate w/o installing R and the package as well. I'm using JMP 17.0 and R 4.2.0. Never saw this error with JMP 16. "Error: C stack usage 4123778 is to...
vigslayer

Discussions |
Dec 15, 2022 8:14 PM

1100 views | 0 replies
How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...
SquaresDingo505

Discussions |
Oct 24, 2022 7:23 PM

861 views | 0 replies
How to Analyze and Graph Responses with Supercategories

I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories. I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification? PS: I don't know how to do JSL scripting.
TCM

Discussions |
Oct 21, 2022 5:59 AM

907 views | 0 replies
標準化列名稱如何用變數取代求解

//新增周標準化
weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
weekEMC_HF_C_12 = {};
//少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
);
Try(
Local( {old dt = Current Data Table()},
Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
For Each( ...
Ken697

Discussions |
Oct 20, 2022 9:22 PM

821 views | 0 replies
Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

710 views | 0 replies