JMP User Community

Latest Discussions

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
Extracting slope of robust fit line

Hi, I am using jsl to create an x-y plot and apply robust fit line.I wish to extract the slope of this line in jsl to store it in an array. I see the intercept information on the picture but the slope information seems to be incorrect.I am not sure even if that is the slope parameter. (please see figure)Any help would be great!
rahulsmils

Discussions |
Jun 30, 2017 3:37 PM

10633 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
Help on a continuous factor values/range for a DOE

Hi, I'm trying to design a DOE for experimenters at my work and I was asked if I can get JMP to include more runs in a specific range of a continuos factor. This factor's values range from 0 to 500 and they think that the range 10 to 100 is most interesting and would like JMP to add more runs within that range than outside it. Is there a way to do this? Any suggestions would help. Thank you.
tnad

Discussions |
Jun 30, 2017 8:35 AM

18445 views | 6 replies
Partial profile conjoint analysis with JMP 13

I would like to run a partial profile conjoint analysis on 6 attributes. I prefer that trials be limited to 3 attributes each (so not to overwhelm the survey taker). Assuming the sample was big enough (each respondent gets 4 trials) and I had many responses of 3-attribute responses, can JMP 13 provide the results that I need to understand the desirability of the 6 attributes?
cjerde

Discussions |
Jun 29, 2017 10:22 AM

5779 views | 3 replies

Previous
Next

Latest Discussions

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
Partial profile conjoint analysis with JMP 13

I would like to run a partial profile conjoint analysis on 6 attributes. I prefer that trials be limited to 3 attributes each (so not to overwhelm the survey taker). Assuming the sample was big enough (each respondent gets 4 trials) and I had many responses of 3-attribute responses, can JMP 13 provide the results that I need to understand the desirability of the 6 attributes?
cjerde

Discussions |
Jun 29, 2017 10:22 AM

5779 views | 3 replies
Select a group of cells in a column

Hi, I have table with thousands of rows. I need to be able to select a group of cells in one column, so I could copy it into another table. for example for Column: "Test3 (VOLTS)" only I need to copy cells highlighted in yellow from row 4 thru row 18 using JSL code.Thanks
SamH

Discussions |
Jun 26, 2017 3:21 PM

16482 views | 11 replies
Adding Data Labels in a graph using scripting

Hello,I need help in adding the Data Labels in a graph using Scripting. I want to display always the data value of the recent row. I marked the column as Label, and I also marked the row as label. But I don't know how can I write the script for the same.
sibanibisoyi

Discussions |
Jun 26, 2017 4:10 AM

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

2279 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