JMP User Community

Latest Discussions

Get schema list from ODBC database

Hi all. Im about to make a script, that fetches tables from an ODBC database. I have managed to use the query builder to do this, but I need to be able to select a schema from a drop down list, as not all users will have access to all schemas. Can anyone help me with an example on how to get the available schemas as a list or similar? It doesnt need to exclusively be the schemas the user has acces...
AWMN

Discussions |
Dec 11, 2019 11:07 PM

4521 views | 2 replies
Continue Script

Hi, so i have a main table (main_dt) which i am going to update (update_dt). However, there are times when update_dt is empty. How do i make it such that the script continues to run? What function do i use for it to continue?
skyzvoir0001

Discussions |
Dec 11, 2019 5:21 PM

2423 views | 1 replies
Analyze Latin squares using JMP

Hi,I would like to analyse some data that is based on a Latin squares design. I have imported the data into JMP, two columns corresponding to the separate blocking variables, one column corresponding to the treatment variable and one column corresponding to the response. However, I am unable to specify more than I blocking column in the Fit Y by X platform. I searched through the discussion archiv...
paul1

Discussions |
Dec 11, 2019 3:23 PM

12881 views | 7 replies
Return value in one column based on location of a value in another column

I have a dataset where devices are identified by lot, wafer, and die; and each part may have multiple tests. I can search the test date column to find when the last test was run on each die, I then need to know from the pass_fail column what the status of the last test was, something like: :PASS_FAIL[ row of Col Maximum(:TEST DATE, :LOTID, :WAFER, :DIE)] I am hoping for a formula that I can use in...
MarkDayton

Discussions |
Dec 11, 2019 9:33 AM

3971 views | 3 replies
Neglect hide and exclude

Hi, Is there anyway to do a summary table or similar based on data that is excluded? I´ve excluded certain rows of data based on requirements in my analysis but I just need to extract a few numbers which have been excluded. Is that possible or do I have to remove the exclude statements (and add them again afterwards)? Br Julie
JulieSAppel

Discussions |
Dec 11, 2019 8:28 AM

7356 views | 9 replies

Previous
Next

Latest Discussions

Change contingency table formatting

When I do a contingency analysis, the numbers in the table are too big for the column and they end up overlapping. I can't figure out how to adjust the size of the columns or the text formatting so that this doesn't happen.
aallman

Discussions |
Dec 11, 2019 5:55 AM

1827 views | 1 replies
Add Row legend to Control Chart

Hey all!

I'm working on some P-charts and I would like to add a legend. First thing I notice is that I can't "click my way" to adding one to a chart. I've tried forcing my script to add it, and that results in an error (as expected).

Any ideas how I can add a legend? I suspect it will involve more advanced scripting techniques, but I'm open :).

Cheers!
Chadd

Example Script:
asdf = Current Data Table(...
Anonymous

Discussions |
Dec 10, 2019 6:12 AM

3372 views | 1 replies
Vibration Analysis: Fault Frequencies Correlations

Hello, I am currently performing a vibration analysis using JMP for the first time. As data input I have FFT (Fast Fourier Transform) data from an extruder gearbox for 5 different time stamps (baseline, pre-event, post-event, 6 month increments after event X2). Each FFT data set comes with 16,000 frequencies (Hz) vs magnitudes (g). In vibration analysis the primary objective is to identify "fault ...
antonio_rmch

Discussions |
Dec 10, 2019 5:42 AM

2666 views | 2 replies
New window size not working

Hi,Would appreciate your help on understanding why the code below does not work.nw2 = New Window("test", <<Size(400,900));The syntax reference says "<<Size(x, y) Creates a new window of the specified height and width.")This works but would like to understand if I am doing something wrong above:nw2 = New Window("test");nw2 << Set Window Size(400, 900);Thanks.
wr

Discussions |
Dec 9, 2019 10:29 AM

5406 views | 1 replies
Changing the Scale of a GraphBuilder graph with attribute data when axis shows nested data

Hello JMP community, I would like to adjust the time scale of a graph builder graph that displays a parameter on the y axis, and lot and date, nested, on the x axis.I found that I had to convert the date to a character format to allow nesting (let me know please if this is not required).However the character date format makes it harder to set the scale of the graph since the scale is a count of th...
JensRiege

Discussions |
Dec 9, 2019 2:49 AM

1854 views | 1 replies

Previous
Next

Latest Discussions

Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1561 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

1929 views | 0 replies
Analysis of covariance (ANCOVA) for Split plot Design

Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
Harun-Or-Rashid

Discussions |
Oct 29, 2019 9:03 PM

1298 views | 0 replies
Send Expects Scriptable Object in access or evaluation of 'Send' Error

I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong? ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...
OneNorthJMP

Discussions |
Oct 10, 2019 8:43 PM

1335 views | 0 replies
Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
jemairsmartes

Discussions |
Sep 11, 2019 10:27 AM

2136 views | 0 replies