JMP User Community

Latest Discussions

Loop Saving Files

Hi, I have a script where a file saves to a particular location. I am saving data files as a string of the product lot number and raw data. I want to be able to run the script multiple times for the same lot number without the files saving over themselves. I want to create some sort of loop that if the file name already exists, then it will save as lotnumber Raw Data (1), lotnumber Raw Data (2) e...
B1234

Discussions |
Feb 12, 2021 12:43 AM

1834 views | 2 replies
JMP14 slower than JMP12 for CSV data loading and manipulation.

Hi, when using jmp14, and running one of the scripts I typically use with JMP12 (which basically loads multiple csv files and does some filtering and concatenating into one final big jmp file) runs much slower than with jmp12. The larger the csv files the larger the difference in speed. I was wondering if there is some fundamental change in JMP14 that would explain this. I'll try to figure where...
eduardoangeles

Discussions |
Feb 11, 2021 10:52 AM

1077 views | 1 replies
JMP Genomics - ANOVA vs deseq2

Hello there. I am new to both JMP Genomics and RNA-Seq data analysis. It appears that JMP Genomics 10 implements ANOVA as a means to determine differential gene expression data. However, that vast majority of RNA-Seq gene expression studies use deseq2 or similar R packages. Has anyone done a comparison (or know of a published report) comparing the two methods? What are the pros and cons? Follow up...
LouisAltamura

Discussions |
Feb 11, 2021 8:48 AM

2033 views | 1 replies
Filtered Spec limit in a control chart for several features

Hello,
I hope you can help me. I'm still very new to JSL. I have the following problem:
I have a table like this:
Feature data USL
A number1 Spec A
A number2 Spec A
A number3 Spec A
B number4 Spec B
B number5 Spec B
B number6 Spec BThe feature should be selected with the data filter. Then the data sho...
Rumo

Discussions |
Feb 11, 2021 5:47 AM

2183 views | 4 replies
How to auto-run attached scripts on a table pulled from database

Following code will attach all jsl scripts in c:\work directory to the table dt. Do you know any function/command which can also make it auto-run on the table? dt = Current Data Table(); dir = "C:\work"; fileNames = Files In Directory( dir ); if (dir!="", For( iFile = 1, iFile <= N Items( fileNames ), iFile++, filename = fileNames[iFile]; show(filename); If( Ends With( filename, ".j...
Dib-Dey

Discussions |
Feb 10, 2021 5:33 PM

1330 views | 1 replies

Previous
Next

Latest Discussions

JMP14 slower than JMP12 for CSV data loading and manipulation.

Hi, when using jmp14, and running one of the scripts I typically use with JMP12 (which basically loads multiple csv files and does some filtering and concatenating into one final big jmp file) runs much slower than with jmp12. The larger the csv files the larger the difference in speed. I was wondering if there is some fundamental change in JMP14 that would explain this. I'll try to figure where...
eduardoangeles

Discussions |
Feb 11, 2021 10:52 AM

1077 views | 1 replies
How to auto-run attached scripts on a table pulled from database

Following code will attach all jsl scripts in c:\work directory to the table dt. Do you know any function/command which can also make it auto-run on the table? dt = Current Data Table(); dir = "C:\work"; fileNames = Files In Directory( dir ); if (dir!="", For( iFile = 1, iFile <= N Items( fileNames ), iFile++, filename = fileNames[iFile]; show(filename); If( Ends With( filename, ".j...
Dib-Dey

Discussions |
Feb 10, 2021 5:33 PM

1330 views | 1 replies
Lineup box disappears upon Save as Report MyReport.jrp

I have a script that creates a window with three tabs. The first tab has a Lineup Box with two columns and 6 Graph Builder graphs created with a loop.nw = New Window( "Win1", tbox = Tab Box(Tab Page Box("Age", vlb = Lineup Box( N Col( 2 )) )) );All the graphs generated by the loop are appended with:vlb << Append( Graph Builder("graph stuff here");At the end everything looks as expected two...
ALopez

Discussions |
Feb 10, 2021 12:25 PM

2432 views | 4 replies
problem to open excel

hi, with JMP 15, I have a ne error message. I don't understand what to do. can someone give me a solution please? best regards
Françoise

Discussions |
Feb 10, 2021 7:39 AM

1898 views | 3 replies
How do I combine these codes?

Hi there, I would like to combine these codes so that they run from the "Formulation Change Review (new)" and closes the new data table/tabulate tab only leaving the graph. Any help much appreciated! (Data Table( "Formulation Change Review (new)" ) << Tabulate( Add Table( Column Table( Grouping Columns( :Lab RFT ), Statistics( Row % ) ), Row Table( Grouping Columns( :Grade ) ) ) )) << Make I...
JC7

Discussions |
Feb 10, 2021 3:53 AM

915 views | 1 replies

Previous
Next

Latest Discussions

generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1090 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1398 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

3931 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1706 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1471 views | 0 replies