JMP User Community

Latest Discussions

Match columns on table update using string

Hello,I'm trying to update one data table with columns from another table, using matching columns criteria defined by a string.In the example below, dt1 is my main table, and dt2 is a sort of config file containing the column to add (i.e. "ROUTE"), while all other columns are used in matching to dt1. Since dt2 is user-defined, I can't know these other column names ahead of time, hence the need to ...
rhakim_gmail_co

Discussions |
Aug 27, 2016 5:55 AM

10827 views | 3 replies
Graph Boxes in the Scripting Index

Hi - I do a quite lot of work with display boxes in general, and Graph Boxes in particular. While trying to find out more about one its properties (which I've actually now resolved), I looked up "Graph Box" in the Scripting Index - but couldn't actually find it. Every other type of display box under the sun appears to be listed, including a Graph Builder Box, but not a Graph Box (though there ar...
DMR

Discussions |
Aug 26, 2016 6:51 AM

11868 views | 3 replies
control chart with multiple items how to save summaries in one table

I have a control chart (cc) window with multiple items (i.e. each item has a control chart). In jsl, when I use cc<< Save Summaries, it pops up a summary table for each item. How can I save all summaries in one table with item name identified? Thank you.
qy6b0

Discussions |
Aug 25, 2016 5:29 PM

8223 views | 5 replies
How do I change the color of the area bordering my charts?

How do I change the color of the area bordering my charts? I can change within the charts, but I would like to have the area where the X and Y axes as the same color (White). When I try to copy the chart and paste it into another program (i.e. powerpoint) the margins of the chart (where legends and X & Y axis numbers are located) is a different color (sort of tan)
diabrotica

Discussions |
Aug 25, 2016 12:52 PM

24467 views | 6 replies
Upload table to MySQL. Columns with TEXT and \n\r

I have a table in JMP with some numeric columns, character columns, date columns and a couple columns with big chunks of text (full of special characters, commas, .I would like to upload this table to MySQL but I am facing some challenges. I have tried several methods:Method 1 - save as csv, upload via workbench/other mysql toolJMP does not seem to code the text pieces (special characters) into th...
morenopelaez_p

Discussions |
Aug 25, 2016 12:51 PM

18581 views | 4 replies

Previous
Next

Latest Discussions

control chart with multiple items how to save summaries in one table

I have a control chart (cc) window with multiple items (i.e. each item has a control chart). In jsl, when I use cc<< Save Summaries, it pops up a summary table for each item. How can I save all summaries in one table with item name identified? Thank you.
qy6b0

Discussions |
Aug 25, 2016 5:29 PM

8223 views | 5 replies
Extract list from Get List Check-command

Using the Get List Check command I get the following:LC = col << Get List CheckThe Log will showLC = List Check({"Argon", "Krypton", "Air"});How do I extract the list from inside the List Check()-statement? I want to end up with a variable containing the list.LC_list = {"Argon", "Krypton", "Air"}
martin_snogdahl

Discussions |
Aug 24, 2016 2:35 AM

4487 views | 1 replies
Automatic Recalc

Is is possible to select Automatic Recalc in Preferences? I have looked for it but cannot find it there. Auto Recalc is a very useful feature in some other software packages I use and it would be great in JMP.
Steven_Moore

Discussions |
Aug 23, 2016 4:52 PM

11201 views | 6 replies
Add script to ButtonBox in jmp report

Dear communityI think my problem is a simple one, but all the same I could use some help. I am using the profiler platform with the added simulator to create a monte carlo simulation of a response with several factors: MyProfiler = Profiler( Y( :Response) ); MyProfiler << Simulator( Factors( Factor 1 << Random(Normal()), Factor 2 << Random(Normal()) ); I want to add some functionality to ...
martin_snogdahl

Discussions |
Aug 19, 2016 7:14 AM

13133 views | 5 replies
Common y-axis scale with fixed interval for all plots

Hi, I'm very new in JMP scripting.I habe many data from my table, my script creates many x-y-diagrams as a jpg-output. For data comparison I want to adjust same y-axis scale (e.g. 0 - 40 beads or 0-0.1%) for all plots. Who can help me?
vuthuy-dung0

Discussions |
Aug 18, 2016 4:37 AM

5444 views | 2 replies

Previous
Next

Latest Discussions

Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4889 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3912 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5194 views | 0 replies
Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3620 views | 0 replies
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3592 views | 0 replies