JMP User Community

Latest Discussions

JSL to select Yes on a prompt

Hello, I am on JMP 16.1 I have a set of data with a range check attached to it with data that is outside of the range that we will always exclude. Correcting the LIMS entry is not an option unfortunately. If possible, how would one script it to always select Yes on the resulting prompt below for the range check? Thank you for any help, every day you learn something new about this program.
ralphtedesco

Discussions |
May 23, 2023 8:43 AM

3606 views | 6 replies
Get Y axis column name from the variability chart

Hi, Is there a way to get the Y axis column name from the variability? I tried using get Y axis but doesn't work. Any suggestions?Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Variability Data/2 Factors Crossed.jmp" ); obj = dt << Variability Chart( Y( :Measurement ), X( :Operator, :part# ) ); ax = obj << get y axis; Show( ax );chart
Jackie_

Discussions |
May 19, 2023 6:17 AM

1944 views | 4 replies
Formatting is not accepted (col << Format( "Fixed Dec", 10, 2 )) and still getting 3 decimal point as the output. What am I doing wrong?

Hello dear community, I am assigning the two decimal point format to a column but when i extract this value it is still showing 3 decimal points. I would appricate your input. Here is an example:// Open Data Table: Antibiotic MICs.jmp // → Data Table( "Antibiotic MICs" ) Open( "$SAMPLE_DATA/Antibiotic MICs.jmp" ); // Standardize column attributes-The main idea is the format= Fixed Dec, 10, 2-show...
Aziza

Discussions |
May 19, 2023 12:39 AM

1859 views | 3 replies
Get values in the list from SQL query

Hi, Is there way I could insert the column values in the list than jmp table?

I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table).
For example, save the WorkCenter sql table values in the list= {};
Any suggestions?

Thanks,Jackie
Jackie_

Discussions |
May 19, 2023 12:04 AM

2652 views | 4 replies
How can I get the sum of all different combinations of a group of columns?

Hi,I am using JMP PRO v16I have a group of 10 columns with numerical values, and I want to try to get a sum of the scores in all possible combinations between these 10 columns (e.g., column A+ column B, column A+ column B + Column C, Column B + Column C and so on). Thank you so much for your help
DivisiveFerret8

Discussions |
May 18, 2023 3:46 PM

3184 views | 6 replies

Previous
Next

Latest Discussions

Formatting is not accepted (col << Format( "Fixed Dec", 10, 2 )) and still getting 3 decimal point as the output. What am I doing wrong?

Hello dear community, I am assigning the two decimal point format to a column but when i extract this value it is still showing 3 decimal points. I would appricate your input. Here is an example:// Open Data Table: Antibiotic MICs.jmp // → Data Table( "Antibiotic MICs" ) Open( "$SAMPLE_DATA/Antibiotic MICs.jmp" ); // Standardize column attributes-The main idea is the format= Fixed Dec, 10, 2-show...
Aziza

Discussions |
May 19, 2023 12:39 AM

1859 views | 3 replies
Get values in the list from SQL query

Hi, Is there way I could insert the column values in the list than jmp table?

I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table).
For example, save the WorkCenter sql table values in the list= {};
Any suggestions?

Thanks,Jackie
Jackie_

Discussions |
May 19, 2023 12:04 AM

2652 views | 4 replies
How to read and update Effect content in the fit model with JSL?

Hi folks,

I have several models in the JMP data table, I know how to read the scripts with JSL. Is there any easy way to extract the effect from this script, make changes and replace with a new effect? If Block is inside the model effect, I need to change it into a random effect to run model again with REML. Thank you so much for your help.
lazzybug

Discussions |
May 15, 2023 12:50 PM

1079 views | 1 replies
JSL to Python Scripting

I am very new to both Python and JSL and am trying to run a script I wrote in Python through the JSL-Python connection. I would like to:1. Select a .txt file from my desktop 2. Send that file to Python3. Execute the tidying procedure I've written 4. Return a JMP table This is currently what my code looks like. Thanks so much for any advice!
efulton2

Discussions |
May 15, 2023 11:59 AM

2314 views | 2 replies
Formule colonne

Bonjour à tous, Je cherche à construire une formule par rapport à plusieurs colonnes de ma base de données. Ce n’est pas si simple à comprendre, je vais expliquer mon objectif à l’aide d’un exemple : Partie grise : Ici, voici 4 type d’objet différents (ENT1,..,ENT4). Chacun des objets est associé à un numéro d’avancement (colonne T), ces numéros sont eux reliés à des opérations bien définis. Part...
hcarr01

Discussions |
May 15, 2023 6:07 AM

5852 views | 16 replies

Previous
Next

Latest Discussions

Criblage des processus

Bonjour à tous,Est-il possible de mettre dans le criblage des processus le format/la colonne de notre choix dans le module « dernière alarme ». Pour ma part j’aimerais pouvoir y mettre une colonne Date pour pouvoir contrôler à quels jour interviennent mes dernières alarmes.Merci pour votre aide.
hcarr01

Discussions |
Apr 3, 2023 2:41 AM

835 views | 0 replies
JMP17 JSL 读取多张表时值为空怎么解决？

JMP17版本用之前15版正常的读取程序，结果为空值。比如第一个表中一行是1,2,3这种值的，第二张表这一系列，是这列，ML1,R1拼接在一起，L1,R1,M1就自动改变亏值。求问大佬怎么解决？dir = Pick Directory( "Select a directory" ); //得到所有文件名，注意要确保所有表格字段名一致，且表格样式一样，否则会得到非预期结果。 files = Files In Directory( dir, Recursive ); If( Contains( files, ".DS_Store" ), files = Remove( files, Contains( files, ".DS_Store" ) ) ); For( i = 1, i <= N Items( files ), i++, fullfile = dir || files[i];...
lehaofeng

Discussions |
Mar 16, 2023 5:58 AM

846 views | 0 replies
What kind of interpolation is used when Scale() is applied to an image object?

Working on a script that processes images and comparing results to a python script that applies similar operations. When I have a script that goes:<image = new image("$SAMPLE_IMAGES/tile.jpg");image << Scale(0.49);> What kind of interpolation is used when changing the image size? Thank you On JMP 16
RoamingForests

Discussions |
Mar 6, 2023 7:17 AM

702 views | 0 replies
JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

913 views | 0 replies
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

1102 views | 0 replies