JMP User Community

Latest Discussions

How to Add Value Labels to a Column through JSL

On my main table (Table 1), I have a column called "Bin" which holds any number (corresponding to the column "Bin Number" entries on another table which is Table 2). Now I want to assign Value Labels to this column "Bin" through script. The value labels would be coming from Table 2 with two columns: "Bin Number" and "Description". Hard-coding something like Column( dt, 1 ) << Add Column Properti...
csoon1

Discussions |
Jul 7, 2017 9:54 AM

8849 views | 2 replies
Replacing Values with Empty Value

I have a script that is based on an imported excel table. I do not have the ability to change anything in the Excel table and have to do all data manipulation and analysis through JMP. The point of the script is to calculate days between dates entered to track project phases. Some of the dates are importing incorrectly as 31Dec1899 based on the way the formula is set up in the Excel sheet and ther...
rfeick

Discussions |
Jul 7, 2017 8:02 AM

5287 views | 4 replies
Choosing a model for a custom design

Hi, I'm curious about your thoughts on how you pick a model for a custom DOE (two continuos factors for example). I know if my goal is optimization, I choose an RS model and JMP will add runs closer to center of the design space, but when I examine the design points, I always get the feeling that there are many large gaps between the factors levels chosen by JMP (I check using scatterplot). This w...
tnad

Discussions |
Jul 7, 2017 3:10 AM

7152 views | 1 replies
JMP 13 Pro trial download

Is there a download page for JMP 13 Pro? I did try to do this but was given a form to fill out but never got a download link in email. Any help in this regard would be greatly appreciated!
mikemalloy

Discussions |
Jul 6, 2017 2:21 PM

6045 views | 1 replies
How to rename the outline box default to "graph builder"

How do I rename the outline box on a graph builder that by default says "Graph Builder"
agonzales2021

Discussions |
Jul 6, 2017 7:58 AM

6339 views | 5 replies

Previous
Next

Latest Discussions

Replacing Values with Empty Value

I have a script that is based on an imported excel table. I do not have the ability to change anything in the Excel table and have to do all data manipulation and analysis through JMP. The point of the script is to calculate days between dates entered to track project phases. Some of the dates are importing incorrectly as 31Dec1899 based on the way the formula is set up in the Excel sheet and ther...
rfeick

Discussions |
Jul 7, 2017 8:02 AM

5287 views | 4 replies
How to rename the outline box default to "graph builder"

How do I rename the outline box on a graph builder that by default says "Graph Builder"
agonzales2021

Discussions |
Jul 6, 2017 7:58 AM

6339 views | 5 replies
Combine many strings into one.

Hi guys, I've a list as per below of string names. I want to concantanate the value of each string in the list, into one combined string. So the result of below would be a string who's value would be "This is a sentence". How would I code this ? Begining = "This"; Middle = "is a"; End = "sentence" StringList = {"Begining","Middle", "End"};
BrianK

Discussions |
Jul 4, 2017 11:03 AM

11636 views | 4 replies
Update existing table with new data without creating output table

Hi,I am trying to write a script that will update my existing table without producing an output table. I have the following code which doesn't seem to work:Data Table("Crea Table") << Update from Database("DRIVER=SQL Server Native Client 11.0;SERVER=REMOVED FOR SECURITY;", "EXECUTE Crea_Table" ,Merge Same Name Columns, By matching Columns(:Lot_Day=:Lot_Day,:Lot ID=:Lot ID), Drop Multiples(1,0),N...
joickle

Discussions |
Jun 30, 2017 4:54 PM

4639 views | 2 replies
I am making a county map of Missouri and labeling each county with the price of acre rental. I have made the map and I have all the data in the JMP excel. I just don't under how to put the labels of the prices on each of the counties.

How do I put the labels on?
jkc5h5

Discussions |
Jun 30, 2017 12:47 PM

6648 views | 4 replies

Previous
Next

Latest Discussions

JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4177 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2041 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4064 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3175 views | 0 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3187 views | 0 replies