JMP User Community

Latest Discussions

How to set up data query for CSV files

Hello everybody, I´ve got the following situation:I have one folder with several csv-files. Every week another csv-file is put into the folder. All the files do have the same structure.At the moment I´m putting the data together by copy and paste into a JMP-file:Every time a new csv-file is available, I copy the data from this file, open the JMP file and paste the new data at the end of my data ta...
JohannesENS

Discussions |
Apr 27, 2022 11:24 PM

1622 views | 2 replies
HTML-like references within a JSL scripted display window

Hi, I have a script that does an analysis on a given data set, and outputs summaries on the first few pages of a report (uses new window() command with various display objects), followed by N pages of scripted analysis for N chosen parameters. All of this is in the same report, and I make use of the page break feature to separate each parameter. N can be any number... just a few or a thousand or s...
mikedriscoll

Discussions |
Apr 27, 2022 6:23 PM

12070 views | 7 replies
Spec limits for Control Chart Builder with multiple phases and where condition

Using JSL in JMP ver. 15.2.0. JSL code is embedded in attached table with script name = 'Control Charts'. I'm struggling with behavior in nested loops when attempting to add spec limits (LSL, Target, USL) via custom graphics script for variable number of phase groupings and 'where' conditions. My nested loops currently result in spec limits for last chart being applied to all control charts crea...
Todd_Lester

Discussions |
Apr 27, 2022 3:42 PM

1055 views | 1 replies
question on right function

Trying to use Right function as below in my jsl codedt << New Column("ORIG_MARK",Character,Nominal,Formula(Right(:result,(Contains(:result,"_",3)))));The result of this statement is as below,but I intend to eliminate the "_" from every row in the ORIG_MARK column.How can I modify the above statement to accomplish this?resultORIG_MARKORIG_MARK_A_AORIG_MARK_B_BORIG_MARK_C_CORIG_MARK_D_DORIG_MARK_E_E
ENTHU

Discussions |
Apr 27, 2022 10:55 AM

1468 views | 1 replies
Possible to update an object in a non-modal window

hello,I have a script that will bring up a column dialog and the manage spec limit platform. I'd like to be able to click the update button and have the manage spec limit table reflect the selected columns. I have not be able to figure this out so the work around is to have the window close and then reopen calling some global variables. Can anyone propose a less cumbersome way of accomplishing t...
shampton82

Discussions |
Apr 27, 2022 8:14 AM

1093 views | 2 replies

Previous
Next

Latest Discussions

How to set up data query for CSV files

Hello everybody, I´ve got the following situation:I have one folder with several csv-files. Every week another csv-file is put into the folder. All the files do have the same structure.At the moment I´m putting the data together by copy and paste into a JMP-file:Every time a new csv-file is available, I copy the data from this file, open the JMP file and paste the new data at the end of my data ta...
JohannesENS

Discussions |
Apr 27, 2022 11:24 PM

1622 views | 2 replies
Spec limits for Control Chart Builder with multiple phases and where condition

Using JSL in JMP ver. 15.2.0. JSL code is embedded in attached table with script name = 'Control Charts'. I'm struggling with behavior in nested loops when attempting to add spec limits (LSL, Target, USL) via custom graphics script for variable number of phase groupings and 'where' conditions. My nested loops currently result in spec limits for last chart being applied to all control charts crea...
Todd_Lester

Discussions |
Apr 27, 2022 3:42 PM

1055 views | 1 replies
Does any one have the script of bootstrap F2 which is used for the comparison of dissolution curves?

Bootstrap f2 is used for the comparison of dissolution curves in pharma industry. I am trying to figure out if any one has built a script for this?
Parsakarthik1

Discussions |
Apr 27, 2022 6:22 AM

6298 views | 10 replies
How to script to submit scheduled job

HiIs there a scriptable way to submit a scheduled job?Thanks
Tomer9w

Discussions |
Apr 26, 2022 10:49 AM

1931 views | 3 replies
Importing multiple files

Dear all, my problem has probably been brought up before as it is quite basic but I couldn't find the solution to my exact problem. I want to import multiple files with the same structure, manipulate them in the identical way and then glue a subset of them together. I have done the importing and data manipulation part in the following generic way:dt = Open( "PATH/File1.xlsx", Worksheets( "Table...
NominalLogNewt5

Discussions |
Apr 26, 2022 8:38 AM

1888 views | 4 replies

Previous
Next

Latest Discussions

How to create a graph builder box plot with mean values, and including the "group X" variable in the legend

I'm using JMP 16.2.0 and I'm trying to automatically generate a graph builder with box plots and their mean values with the group X variable as the color. I'm using a bar chart with style=floating to display the mean value (inspired by this topic)My current graph:This is almost what I want, except for a few things.1. I'd like the Group X variable (Recipe) to be visible in the legend as well. One w...
mvanderaa1

Discussions |
Apr 20, 2022 4:13 AM

2550 views | 0 replies
Error When Trying to Create User to Access the JMP Virtual Lab

While taking the Exploratory Data Analysis module, it is time to practice. However, when trying to access the JMP Virtual Lab, I cannot get past the "Create User" option. JMP VIRTUAL LABTo use the Virtual Lab, please select the Create User link below. If you would prefer to use software on your own machine, please select the Download Data link below.
Create User Download Course Data Clicking the C...
TielsForTheWin

Discussions |
Apr 14, 2022 10:48 AM

803 views | 0 replies
Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

851 views | 0 replies
No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

607 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

786 views | 0 replies