JMP User Community

Latest Discussions

UNION QUERY - HOW TO DO IT?

Dear All, We are looking for your help. We are creating a query that extract the data from several tables (as usual), but we would like to do a Union between two primary tables. An example of how our SQL query looks like is below. How can we achieve this using the Query Builder? So far, we can query the db using only the first part of the query before the UNION statement. We have read the JSL book...
anaheilman

Discussions |
May 10, 2018 2:16 PM

4706 views | 5 replies
Column quantiles or probabilites by ...

I need jsl code that will save the probabilities of a given column distribution, by other columns. I know how to do this un-scripted by taking a distribution of the column by the other columns and then under the red action button while holding control, and selecting Save Prob Scores. But I don't know how to script this.I looked through other posts but didn't find an answer to how to script the ab...
pcarroll1

Discussions |
May 10, 2018 12:44 PM

7909 views | 4 replies
List of tables: how to interactively update and not loose the selection

I have seen discussion on this topic, and I couldn't find the solution.The problem is the following: I'm orking with the list of tables that is displayed in a List Box. I use N Table() way of getting a list of names for all the tables.What I want is that if I click to select any lines in that list - the list itself updated and checked if there are new opened tables or some tables were closed.Good ...
miguello

Discussions |
May 10, 2018 12:00 PM

5130 views | 4 replies
Graph Builder issue with parallel plot

Hi, I am using graph builder to plot three varaibles using the parallel option. I have attached the plot. I am not sure why there is no scale on y axis and what does the arrow sign mean in the top of the graph? Thanks for your help.
AT

Discussions |
May 10, 2018 11:50 AM

5778 views | 5 replies
No Value{160} Error ?

All,
I have a well functioning namespace that works fine when called on. However, when I have this in a loop, it is throwing an error No Value{160}. It is generating a table that i expect - but half way through after building some columns it is throwing this error. Data is confidential and I can't share but I am perplexed why this would happen, despite the fact that reference variable points...
uday_guntupalli

Discussions |
May 10, 2018 10:54 AM

2069 views | 2 replies

Previous
Next

Latest Discussions

UNION QUERY - HOW TO DO IT?

Dear All, We are looking for your help. We are creating a query that extract the data from several tables (as usual), but we would like to do a Union between two primary tables. An example of how our SQL query looks like is below. How can we achieve this using the Query Builder? So far, we can query the db using only the first part of the query before the UNION statement. We have read the JSL book...
anaheilman

Discussions |
May 10, 2018 2:16 PM

4706 views | 5 replies
List of tables: how to interactively update and not loose the selection

I have seen discussion on this topic, and I couldn't find the solution.The problem is the following: I'm orking with the list of tables that is displayed in a List Box. I use N Table() way of getting a list of names for all the tables.What I want is that if I click to select any lines in that list - the list itself updated and checked if there are new opened tables or some tables were closed.Good ...
miguello

Discussions |
May 10, 2018 12:00 PM

5130 views | 4 replies
Graph Builder issue with parallel plot

Hi, I am using graph builder to plot three varaibles using the parallel option. I have attached the plot. I am not sure why there is no scale on y axis and what does the arrow sign mean in the top of the graph? Thanks for your help.
AT

Discussions |
May 10, 2018 11:50 AM

5778 views | 5 replies
No Value{160} Error ?

All,
I have a well functioning namespace that works fine when called on. However, when I have this in a loop, it is throwing an error No Value{160}. It is generating a table that i expect - but half way through after building some columns it is throwing this error. Data is confidential and I can't share but I am perplexed why this would happen, despite the fact that reference variable points...
uday_guntupalli

Discussions |
May 10, 2018 10:54 AM

2069 views | 2 replies
Using a user-defined equation to create a distance matrix

Hello, I am trying to create a distance matrix of similarity/dissimilarity values for community data. I would like to use a specific equation (Bray-Curtis) to construct the matrix of values; values will show similarity in multiple species abundances between multiple plots. I am aware of the method to create a distance matrix in JMP using hierarchial clustering, but do not know how to perform a ...
hjh

Discussions |
May 9, 2018 3:20 PM

5091 views | 1 replies

Previous
Next

Latest Discussions

Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1713 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3815 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2634 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2262 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3502 views | 0 replies