JMP User Community

Latest Discussions

Table Update from Access Database do not work with jmp 16

In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables. Current Data Table() << Update From Database( "DSN=Test;DBQ=filelink\filelink\file.mdb", "SELECT * FROM [file]" )
Metin_Tueluemen

Discussions |
Sep 30, 2022 8:14 AM

616 views | 1 replies
Need to create a column based on sequence of variable appear in another column

Hi All,
I want to create a column based on :Client_ID and how many times ( a number of sequence is counted as 1 count only, see the the :Comment column) it is appearing in the data set. My requirement is :Final Requirement and would be happy to have :Required Column 1 as well. I can not re-arrange/sort the data.Any help please ?Many thanks, -HSS

HSS

Discussions |
Sep 30, 2022 6:52 AM

2248 views | 8 replies
How to stretch GB to fill all available space?

Let's say I have a 3 column Line Up box with some display boxes, and then as a second row I have an Unlineup Box with a Graph Builder inside.Example can be seen by running this script:dt = New Table( "DEMO", Add Rows( 10 ), New Column( "Category", Character, "Nominal", Set Values( {"A", "A", "A", "A", "A", "B", "B", "B", "B", "B"} ) ), New Column( "X", Character, "Nominal", Set Val...
miguello

Discussions |
Sep 30, 2022 6:21 AM

1245 views | 4 replies
Is there a way to make the rowstate handler less laggy?

Is it possible to make the rowstate handler only fire on mouse up or after a selection event is completed? The realtime event causes drag select from my graph to lag and makes the user experience unpleasant. I've gone so far as to completely rewrite a selection event in the mousetrap thing but I'm having trouble applying it to histograms and I don't even love how it's performing either. It would...
xxvvcczz

Discussions |
Sep 29, 2022 6:42 PM

3496 views | 11 replies
How to delete all files in a folder?

A folder contains no folders but multiple files.
How can I delete these files using JSL?
Because this folder is occupied by other levels, cannot be achieved by deleting the folder.rd1=Delete Directory(dir);rc1=Create Directory(dir); Thanks!
lala

Discussions |
Sep 29, 2022 4:16 PM

1429 views | 3 replies

Previous
Next

Latest Discussions

Table Update from Access Database do not work with jmp 16

In our company there is an access database for rheology measurements. We can update rheology jmp tables from this database file (.mdb) by using jmp 14.3. Now we are using jmp 16.2 and the update script do not work anymore. Every time I have to open jmp 14 to update the tables. Current Data Table() << Update From Database( "DSN=Test;DBQ=filelink\filelink\file.mdb", "SELECT * FROM [file]" )
Metin_Tueluemen

Discussions |
Sep 30, 2022 8:14 AM

616 views | 1 replies
How to stretch GB to fill all available space?

Let's say I have a 3 column Line Up box with some display boxes, and then as a second row I have an Unlineup Box with a Graph Builder inside.Example can be seen by running this script:dt = New Table( "DEMO", Add Rows( 10 ), New Column( "Category", Character, "Nominal", Set Values( {"A", "A", "A", "A", "A", "B", "B", "B", "B", "B"} ) ), New Column( "X", Character, "Nominal", Set Val...
miguello

Discussions |
Sep 30, 2022 6:21 AM

1245 views | 4 replies
How to have a mixture of mixtures design

Hi, I am developing a cell culture medium based on 4 prototypes. These 4 prototypes are basically contain same components but at different level, Prototype 1 is lean, prototype 2 is rich in amino acid, prototype 3 is rich in vitamin and prototype 4 is rich in trace element. I will mixture different level of the 4 prototypes to have a new mixture media.I understand this is a mixture of mixtures des...
loganshawn

Discussions |
Sep 29, 2022 12:06 PM

3188 views | 3 replies
Matched pairs reference frame

I don't seem to be able to get the reference frame to show up on the resulting graph by selecting a preference (see screenshot)? Is this a feature, a bug, or my ignorance of what option to select? (I can turn it on using the Little Red Triangle [because that's my friend!].)
sfigard

Discussions |
Sep 29, 2022 6:17 AM

1076 views | 3 replies
Destruction Degradation and Arrhenius Equation.

I have stability data at three different temperatures (5C, 25C and 40C) and I am trying to use Arrhenius model to predict the estimate of impurity at 25C after 24 months. What model should I use in JMP?
HermieSingh

Discussions |
Sep 29, 2022 2:36 AM

1458 views | 1 replies

Previous
Next

Latest Discussions

Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

415 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

486 views | 0 replies
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

517 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

568 views | 0 replies
JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

576 views | 0 replies