SQL code for "Stack" and "Split" JMP buttons
Hi, Does anyone have a SQL code equivalent for the "split" and "stack" options under JMP Tables menu? Those are very slick and was wondering if there was someone that might know how to do those in SQL?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, Does anyone have a SQL code equivalent for the "split" and "stack" options under JMP Tables menu? Those are very slick and was wondering if there was someone that might know how to do those in SQL?
Dear all,since a few weeks I observed strange behaviour of my JMP Pro 16.1.0 on Win10.When I double click in Explorer on a script file, it is automatically executed (and not opened for editing as I would expect, and as it is true for other installations I know).This is although there is no "//!" in the first line, that would tell JMP to execute it on open.Also a "reset associations" in preferences...
Hi,I performed a three-way anova to see the effects of factors(CO2, irrigation and cultivar) on the wheat grain numbers.Effects shown that the interaction of CO2 and Cultivar was not significant(p>0.05), but the Tukey test seems there is the interaction between them.When I look into the interaction of CO2 and irrigation, they looks similar to the interaction of CO2 and cultivar, but the effects t...
Hi,I have the diameter symbol ⌀ as a char in a column in a DB table (it was created with Excel but it is complicated to prevent typing in the symbol because many people are working with that and there are historical data which I dont want to change...). The JMP Query (via JSL) imports the symbol correctly. But when I want to insert the symbol back into a DB table, it exports an ? instead of the ⌀....
Hi, I'm new here.I used the JMP to draw some choice sets for a choice modelling project. I have 32 choice sets however I need to choose the best 4 out of the 32 choice sets. I would like to know how to do that using the software. I generated these 32 choices from the JMP software using (DOE- consumer studies--Choice design) options from which I want to choose the best 4. I keyed in 3 attributes wi...
Dear all,since a few weeks I observed strange behaviour of my JMP Pro 16.1.0 on Win10.When I double click in Explorer on a script file, it is automatically executed (and not opened for editing as I would expect, and as it is true for other installations I know).This is although there is no "//!" in the first line, that would tell JMP to execute it on open.Also a "reset associations" in preferences...
Hi,I performed a three-way anova to see the effects of factors(CO2, irrigation and cultivar) on the wheat grain numbers.Effects shown that the interaction of CO2 and Cultivar was not significant(p>0.05), but the Tukey test seems there is the interaction between them.When I look into the interaction of CO2 and irrigation, they looks similar to the interaction of CO2 and cultivar, but the effects t...
Hi, I'm new here.I used the JMP to draw some choice sets for a choice modelling project. I have 32 choice sets however I need to choose the best 4 out of the 32 choice sets. I would like to know how to do that using the software. I generated these 32 choices from the JMP software using (DOE- consumer studies--Choice design) options from which I want to choose the best 4. I keyed in 3 attributes wi...
Is there a way to group by in Variability charts? If i have several samples I want to group by the sample and draw a cell means and bars for each sample. Here's an example that JMP generates: It's just plotting one cell mean, but I want to draw separate cell means grouped by each sample individually. Seems like it's impossible to do that right? This is what I want to be able to do: *EDIT: I know...
Hi Guys, I am a new user of JMP, I want to create a multi-Y axis graph. Please refer to the attached images below. Can someone suggest me best and easy way to do this? I am not sure how to create the datasheet in JMP for that but I have my data ready in an excel sheet. Thanks in advance
Hello,I need to change the locations of the separators line in the graph.In the attached image, I need the separators lined on the upper row (labeled ISI).I have tried to find how to do that without success.Thanks
Ive been using JMP on the Mac for a few years and now have to us the PC version (JMP® 16.1.0 (539038)
Microsoft Windows 10 Pro 64-bit (10.0.19042.0). I use graph builder a lot and find that the axis (either) "scale format" defaults to "fixed decimal" which does wacky things when trying to use certain increments for the scale.This is with the X axis set at increment of 0.05 with fixed decimal This...
Hi JMP Community, I just came across an odd behavior in GraphBuilder with the Parallel Plot > Sankey Plot. If I limit the input to a maximum of 66 rows, the plot looks good. However, if I bump the number of rows to 67 or more,the output is no longer useful: no annotations: Is there a trick to maintain the axis annotations as shown in the first plot? Thanks. Best, TS
Every time I try to save something I'm working on jump this mesage shows up. Also, I can't open figures other people do on the project we share and the folders I have download in the past week to the project are also gone. How can I solve this problem? Reinstalling would help?
I'm trying to do permutation tests and Monte Carlo Cross Validations with the Iris sample dataset as a MWE for our dataset. I'm not sure if I'm doing things and interpreting output correctly. 1) Create New Formula Column (Random->Sample Without Replacement) for the Species Column for Permutation Test. 2) Create a Validation Column (0.75/0.25 split) and a new Formula Column (Random->Sample Withou...
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Do you face challenges with restrictive data formats from EDS, XRD, or Raman instruments? Are the ex...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...