JMP User Community

Latest Discussions

Query Too Slow for Script

I have used Query Builder to script several queries. Then I placed these scripts back to back. Next I want to work with the new data tables formed form the queries. My problem is that one of the queries takes >10 seconds to run, and the JSL following the queries tries to work with the "to-be-formed" table (which is not there when the script gets to that portion of the code). This obviously causes ...
Martin

Discussions |
Jun 2, 2017 5:28 PM

13607 views | 8 replies
Best method to do Failure Rate comparison

Hi, What is the best method to do a failure rate comparison between two process.
albiruni81

Discussions |
Jun 2, 2017 1:46 PM

15164 views | 10 replies
JSL automate the columns used in Process Capability

Hello,so i want to write a JSL script that can run Process Capability on the click of a button on a tool bar. i have every thing coded except for Process Variables. see code below. how will i be able to dynamically add the columns in "process variables()"func_Process_Cap = Function({summ_table,spec_table}, // local vars {}, Process Capability( Process Variables( // hard coded - not ideal...
jay_S

Discussions |
Jun 2, 2017 11:15 AM

8796 views | 4 replies
Add Column Data from One Table to Already Existing Table

Hi, I am trying to add column data from one output table (called "output") to an EXISTING TABLE (called "Stanmore and Lam"), but when I use the join command it creates an empty new output table. My code is as follows:output = New Table( "Output", AddRows( 1 ), New Column( "Y (coronal) mm", Numeric, Continuous ), New Column( "X (sagittal) mm", Numeric, Continuous ) ); :"Y (coronal) mm" << addRow...
nqj

Discussions |
Jun 2, 2017 8:43 AM

9057 views | 4 replies
Insert Current Date in Output Table

JSL Gurus! I need your help trying to change the name of a JOIN output table. I'm in the process of scripting a JOIN from last month's file and this month's file. I'd like the output to be renamed to "Main Table" and the current month (201706). Ex: "Main Table 201706" Is this possible? To be discussed later, when I get to next month I'll make that new file (Main Table 201706) the current dt, join ...
Risslemc

Discussions |
Jun 2, 2017 8:32 AM

8822 views | 3 replies

Previous
Next

Latest Discussions

Function for back button

Hi, everyoneI can create a button named as "Back". But may I know is there any function that can back to the previous interface when i click the back button?
Thanks.
jade

Discussions |
Jun 2, 2017 4:50 AM

3712 views | 2 replies
Parallel Processing in Scripting

In the process of putting togother a lengthy script that makes some calls to ODBC/SQL databases that can each take several minutes to run. In an ideal world I could be waiting for multiple servers to get back to me at the same time. From what I am gathering I have to stick with just running one database request after another?I am running JMP 9.
firemandan9

Discussions |
May 31, 2017 12:46 PM

7109 views | 4 replies
Disabling all or individual check boxes not able to be re-enabled with opposite method

I have two sets of check boxes and one is being used to control which options are enabled on the other. I seem to have run into an issue using Enable and Enable Item. If I have previously disabled all the checkboxes I am unable to enable them individually unless I enable them all first. Conversly, if I disable individual check boxes, it appears I am unable to enable them all at once. As it is curr...
SG

Discussions |
May 30, 2017 12:14 PM

3819 views | 1 replies
how to change the range of this graph ?

i am attaching a image of the graph, in this graph if you can see on the y-axis all the ranges are from 015 to 15. But if you can see only C15 label has higher value than 15 but the other labels are less than 5 for C14 and C16. So how can i change the values of C14 and C16 to lesser values like 8 in this case for C14 and 5 for C15. Plz share your opinion. Also the values are much coarser i.e +15 ...
Drharsha

Discussions |
May 28, 2017 3:58 PM

6569 views | 3 replies
apply my PLS model to new data

Hey all, I am using Partial Least Squares (PLS) analysis to find a model to predict concentration of sustance from spectral data - which means I have 6800 variables.After tweaking the data, resampling, tweaking some more and other things I seem to have found a predictive model that I can trust. My question isHow can I apply this model to new data? even one sample at a time. Thanks!Amir PS - Using ...
anakar

Discussions |
May 26, 2017 11:54 AM

7612 views | 2 replies

Previous
Next

Latest Discussions

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

2334 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

4587 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

3469 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

3591 views | 0 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4585 views | 0 replies