JMP User Community

Latest Discussions

Update Column at Specified Rows

Hello, I try to use the "For each row" and "Begin Data Update" script commands to update the calculation on specific row related to a column.According to the table below, I intend to have two addition columns, Defective Rate (%) and Yield, and they both use the same equation of cell qty/daily total. However, Defective Rate (%) column will only calculate the rows where Category = Reject & MRB, and ...
bernie426

Discussions |
Jul 12, 2016 5:42 PM

13006 views | 3 replies
Extract and concatenate csv files from folders that have the same structure

Hi,I have a whole bunch of csv files in different folders that have common name and csv file is in the same structure, for instance<1st folder>dfgdwgssd <2nd folder which have common name> commonname xxx-commonname.csvI'm thinking to use script to extract and concatenate all csv files. I found an easy way with bash commands ("for" loop together with "find"), could some one give me a h...
jyw

Discussions |
Jul 12, 2016 9:43 AM

18471 views | 9 replies
Scripting to format contour plots

I'm currently running a simple script to output contour plots from my data table. Is there a way of including the colour scheme I was to use and the fill area command as part of this script, as currently I'm having to do it for each plot individually/manually.cheers!
laragrew0

Discussions |
Jul 11, 2016 9:09 AM

5933 views | 2 replies
How to select every other and third row?

Hello,I am a new user, so please excuse me if this seems like an easy question to answer.I have a data set (21k+ rows) where I want to select the 2nd and 3rd row, unselect the 4th, then select the 5th and 6th, unselect the 7th....so on...After they are all selected, they can be deleted, as I don't need the data in those rows.What would be the easiest way to do this?Thank you very much.-Matt
mmcclusk0

Discussions |
Jul 10, 2016 4:09 PM

20956 views | 6 replies
What do you call JMP's red triangles?

The Red Triangles in JMP reveal contextual drop down menus that show relevant commands. JMP features contextual menus accessed via small red triangles throughout the software. Some JMP users call them hot spots, inverted red triangles, or just triangles.Feel free to Comment below on what you call them.

Narration: When selected, the red triangles reveal contextual drop down menus allow us to cus...
ryandewitt

Discussions |
Jul 10, 2016 2:33 PM

22661 views | 13 replies

Previous
Next

Latest Discussions

Scripting to format contour plots

I'm currently running a simple script to output contour plots from my data table. Is there a way of including the colour scheme I was to use and the fill area command as part of this script, as currently I'm having to do it for each plot individually/manually.cheers!
laragrew0

Discussions |
Jul 11, 2016 9:09 AM

5933 views | 2 replies
What do you call JMP's red triangles?

The Red Triangles in JMP reveal contextual drop down menus that show relevant commands. JMP features contextual menus accessed via small red triangles throughout the software. Some JMP users call them hot spots, inverted red triangles, or just triangles.Feel free to Comment below on what you call them.

Narration: When selected, the red triangles reveal contextual drop down menus allow us to cus...
ryandewitt

Discussions |
Jul 10, 2016 2:33 PM

22661 views | 13 replies
ReNaming Of Data Table using Row Information

I use routinely Query Builder to output files from a database but get into problems because they all have the same name ( apart from a (1), (2) etc after the name and so I then have go manually go and alter the name to match the experiment the data comes from.How would I run a script to alter the name to match a certain column or columns in the data table?So in the attached example I want to chang...
d_barnett

Discussions |
Jul 10, 2016 11:44 AM

4637 views | 2 replies
Problems with Data Filter and Plots Autoupdating

I'm trying to use sliders and have a data filter at the same time. The problem I have is that when I open my filter, moving the sliders causes the figure to no longer update. Without the filter, the figure updates fine. The sliders are hooked up to Table Variables that then are used in columns for calculations. I opened the data sheet and the numbers are still changing as well as the equations. Un...
pbrett

Discussions |
Jul 8, 2016 7:21 AM

6349 views | 5 replies
How to interpret the X and Y axes in the (Multivariate Clustering) Constellation Plot?

This may seem like a newbie question, but I've been trying to answer this on my own and not making any progress. I understand the concept of the Constellation Plot intuitively as showing the membership in clusters as they're built up from the dendrogram. JMP puts labels on the axes (-200 to +200 in my case), which begs the question. The explanation that "Longer lines represent greater distances be...
mbordt_gmail_co

Discussions |
Jul 8, 2016 7:16 AM

5980 views | 3 replies

Previous
Next

Latest Discussions

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

3798 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

3812 views | 0 replies
Generalized Segmented Distributions

A former classmate of mine from Graduate School has recently published a paper on Generalized Segmented Distributions. Utilizing this method, the distribution can approach any continuous density function of arbitrary form. The method is particularly effective in fitting data with sufficient observations that are skewed and/or multimodal. The paper can be found here:The General Segmented Distrib...
Steven_Moore

Discussions |
Sep 17, 2015 11:54 AM

2524 views | 0 replies
Running JSL Script After Creation of a File

sophiaw

Discussions |
Sep 1, 2015 9:56 AM

2813 views | 0 replies
Clash?

saitcopuroglu

Discussions |
Aug 18, 2015 6:43 AM

2551 views | 0 replies