JMP User Community

Latest Discussions

List of expressions

I'd like to build up a list that looks like this. LL = {parm1 = "x", value1 = 5, parm2 = "y", value2 = 3, ...}The length may vary, so I'm doing it in a loop and trying to use the loop index in the variable name.But I am having difficulty creating that term (e.g. parm1).What is the best way to do this?
pcarroll1

Discussions |
Jul 7, 2017 12:26 PM

11308 views | 5 replies
How to use Number Edit Box new value

Hello everyone! I feel like such a novice today. I cannot seem to find clear information on how to have Number Edit Box values update a Window, other Number Edit Boxes, and equations when values are changed. My biggest issue is that I have over 30 Number Edit Boxes that feed 2 equations/formulas. Setting the starting values, I have down. If a value is changed, everything else needs to update ...
WendyLou315

Discussions |
Jul 7, 2017 10:41 AM

9095 views | 4 replies
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

9501 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

6132 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

7733 views | 1 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

6132 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

7197 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

12713 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

5176 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

7349 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

4567 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

2280 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

4525 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

3426 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

3539 views | 0 replies