JMP User Community

Latest Discussions

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

9058 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

8824 views | 3 replies
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

3713 views | 2 replies
How Do I get the number of Data Tables

Hello,so i have a script that gets a data table with data and a data table with its specs. when i manually run Process Capability i can choose the columns and use the spec table and everything works like intended.the Problem:I am trying to run this through a JSL script. the idea is to get a list of the currently open data tables, open a new window, have a dropdown with the list of data tables, and...
jay_S

Discussions |
Jun 1, 2017 6:52 PM

5735 views | 1 replies
Counting rows

I have a data set with multiple lines of data per individual. The lines of data are medical procedures and I want to get the average number of lines (or procedures) per individual. I'm not sure how to do that. I was able to count the number of lines but I can't take the mean of that since everyone who has 5 lines also has 4 lines and 3 lines and so on. So basically what I think I need is for JMP t...
jswislar

Discussions |
Jun 1, 2017 5:03 PM

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

3713 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

2335 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

3594 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

4586 views | 0 replies