JMP User Community

Latest Discussions

Apply script to multiple data tables

I have a script where I open a txt file in JMP as a data table and then move the column names listed in row 7 to the column headers. How can I apply this to multiple data tables? My current script is not working. I have JMP16. Thanks. dt_list = Multiple File Import(); //additional known text here to open files table_script = expr( //Move the column names listed in row 7 to the column headers dt...
Raquel

Discussions |
Jan 16, 2024 11:55 AM

1853 views | 4 replies
How to store variable values in a list properly?

The first 6 lines of the script below work as I expected, with output copied below.Then I tried to store the values of these variables in a list, which didn't go well. It appears that the variable names instead of the values were stored. How do I store the variable values in the list? Thank you! dt = new table("my table", new column("X", set values({-0.35, 0.15, 0.3}) ) ); dt << new column("Y", s...
CurseOfLizard13

Discussions |
Jan 16, 2024 7:49 AM

1416 views | 2 replies
Show only one graph out of a matrix of graphs

When there is a matrix of graphs, say 4x5 of them on the dashboard, how do I pick just one graph of all and show it zoomed in? The selection does happen when a data filter is used when the two columns from the data table used to form the graphs in the horizontal and vertical direction and are narrowed down to a desired pair. It would be useful to have a single zoomed in graph where this selection ...
JMPer1

Discussions |
Jan 16, 2024 7:43 AM

1261 views | 3 replies
how to calculate yield for many columns with embedded spec limits

Hi,I have over 60 columns where individual spec limits are embeded in column properties. I like to calculate the yield for each row as Pass/Fail. I appreciate any script that will do this. I checked the JMP discussion and found one script that does yield but each columns is assumed to be pass or fail (1 or 0). Thanks
AT

Discussions |
Jan 16, 2024 7:37 AM

14182 views | 17 replies
JSL: How to call outlinebox on calculated string, like: Report(platform)[OutlineBox(parse("Stepwise Fit for " || yparm))]

Hello, i try to call my outlinebox report by substituting with the table variable name (character string) I want to look at.I first tried without substitution and it worked well.Then i did: NamesDefaultToHere(1); yparm = "MyResponse1"; dt = DataTable("MyDataTable"); ... platform = dt << Fit Model( ... , Personality("Stepwise"), ... ); wait(0) ; TableToGet = Report(platform)[OutlineBox(parse("S...
MeanTableColt51

Discussions |
Jan 16, 2024 3:05 AM

1380 views | 3 replies

Previous
Next

Latest Discussions

Show only one graph out of a matrix of graphs

When there is a matrix of graphs, say 4x5 of them on the dashboard, how do I pick just one graph of all and show it zoomed in? The selection does happen when a data filter is used when the two columns from the data table used to form the graphs in the horizontal and vertical direction and are narrowed down to a desired pair. It would be useful to have a single zoomed in graph where this selection ...
JMPer1

Discussions |
Jan 16, 2024 7:43 AM

1261 views | 3 replies
Open files from same directory for Workflow

Hello Community, I only just recently started working with JMP Workflows and JSL Scripts and was wondering to create something in code to achieve the following: - The goal is to move a workflow (copy/paste) to a specific folder, where other files like .xlsx and .csv are located. The designed script should then open a specific .csv file from within the same folder the script or workflow is located ...
Gab_K

Discussions |
Jan 15, 2024 12:01 PM

736 views | 0 replies
Should the standard deviation of BLUB´s not be equal to the square root of variance component?

BLUB´s (random effect predictions/random coefficients) seems to be calculated by scaling the centered Means with the Variance Component divided by Variance of Means. However, this causes BLUB´s to have a lower standard deviation than the square root of the variance component. If they were scaled by the square root of the Variance Component divided by Variance of Means, the standard deviation of th...
pv

Discussions |
Jan 15, 2024 2:36 AM

972 views | 1 replies
How to create a design that combines finding the best combination of substances together with finding their best concentration?

Dear JMP team,I am planning an experiment, where I have two categories of molecules (categoryA and categoryB). Both have two possible molecule candidates each: categoryA = {molA1, molA2} and categoryB = {molB1, molB2}. I would also like to model the concentration of each molecule as independent factor. I was first thinking to add two continuous factors like ConcentrationCategoryA and Concentratio...
statQue12

Discussions |
Jan 15, 2024 2:10 AM

1290 views | 2 replies
JMP Script question: How to use variables to control "show group means"?

Hi all:
I have a question about Variability chart. I am trying to use a variable "aaa" to control if the a certain variability chart need group means.
Below is the simplified code:
According to the log file, it seems that jmp does not substitute aaa to 0 so that it still plot group means even if
aaa=0.
Is there any way to let jmp to realize aaa is a variable?
Note: The values of aaa could be 0, 1 or "Sp...
ytwu

Discussions |
Jan 14, 2024 10:37 PM

878 views | 1 replies

Previous
Next

Latest Discussions

Open files from same directory for Workflow

Hello Community, I only just recently started working with JMP Workflows and JSL Scripts and was wondering to create something in code to achieve the following: - The goal is to move a workflow (copy/paste) to a specific folder, where other files like .xlsx and .csv are located. The designed script should then open a specific .csv file from within the same folder the script or workflow is located ...
Gab_K

Discussions |
Jan 15, 2024 12:01 PM

736 views | 0 replies
query in topic modelling

how to find coherence values in topic modeling. Moreover how to plot topic proportion and and publication years in text explorer option
FrequencyBeetle

Discussions |
Jan 11, 2024 4:20 AM

619 views | 0 replies
Acrobat OCR settings for preparing PDFs for import using the PDF import wizard

Just sharing an issue I had with Adobe Acrobat and the JMP PDF Import Wizard in case others come across the same problem.A few months ago I had a workflow where I needed to perform OCR on PDFs in Acrobat (Pro) before I could use the PDF Import Wizard to pull data from the PDFs into JMP - this had been working fine for a long time.When I tried this again last week I had an issue where many pages wo...
jc510_2

Discussions |
Jan 8, 2024 2:02 PM

1465 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

1043 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

702 views | 0 replies