JMP User Community

Latest Discussions

How do I use a relative folder path in multiple file import?

Members of my group use a Sharepoint workspace that includes raw test data that we'd like to import and process in JMP. Our shared script for processing that data is stored within the Sharepoint workspace itself, which seems to present problems for defining the folder path for the multiple file import function. It seems that Microsoft defines the path for a mounted Sharepoint or OneDrive folder as...
alan_h

Discussions |
Sep 22, 2022 11:03 AM

1618 views | 3 replies
How to concatenate rows in a given column to a string in JSL?

If I have a datatable dt with one column col1 and several rows containing characters e.g. a, b, c, d i.e. one character per row. How do I get a string of the form myString = 'a','b', 'c', 'd' ? If I do this x = Associative Array( dt:"col1" ) << Get Keys; show (x);it gives me x = {"a", "b", "c", "d"};whereas I would like to get a string myString = 'a', 'b', 'c', 'd'to use further in my next line ...
Neo

Discussions |
Sep 22, 2022 9:59 AM

956 views | 1 replies
How to recode a column with a formula in JSL

I am having trouble getting my recode script to run correctly. I have a data table with a column called DEPT which contains a number which corresponds to a specific departent name. What I want to do is create a new column called Dept Name that takes the values in DEPT and converts them to the written department name rather than the numeric version. This table is part of a larger script that I run ...
rfeick

Discussions |
Sep 22, 2022 9:06 AM

12904 views | 5 replies
Why is a cell in a new row blocked with an "X"?

Hi all, while manually entering a new row into a data table the corresponding cell in the third column immediately is blocked with a black "X". See attached photo. Any idea as to why this is happening? I closed all graphs associated with the data table. The first two columns are scroll-locked for easy viewing which is the only thing I notice that might be a factor. It looks like a number can be en...
jmv

Discussions |
Sep 22, 2022 6:37 AM

992 views | 2 replies
Change graph background colour between reference lines

Hi, I have a scatter plot with a line of best fit to which I've added 2 reference lines to the x-axis.Is there an easy way of changing the background of the area between both reference lines to light-grey. Thanks!
Agustin

Discussions |
Sep 22, 2022 5:29 AM

1097 views | 2 replies

Previous
Next

Latest Discussions

How do I use a relative folder path in multiple file import?

Members of my group use a Sharepoint workspace that includes raw test data that we'd like to import and process in JMP. Our shared script for processing that data is stored within the Sharepoint workspace itself, which seems to present problems for defining the folder path for the multiple file import function. It seems that Microsoft defines the path for a mounted Sharepoint or OneDrive folder as...
alan_h

Discussions |
Sep 22, 2022 11:03 AM

1618 views | 3 replies
Using FORMULA for pasting the alues from one column based on the other column using IF statement

I am trying to fill the column of Slopes_1 and Intercept_1 (1000 rows) from Slopes and Intercept (36 rows), respectively based on if Cycle 2(1000 rows) matches Cycle 3 (36 rows)Can you suggest a formula to be inputted in Slopes_1 and Intercept_1 ?
AlphaPanda86751

Discussions |
Sep 21, 2022 8:11 AM

747 views | 2 replies
Customize Response Surface model picking weird number other than lower/center/upper level.

Hi all, I ran a initial DSD and now trying to follow up with Custom Design with some interaction term mimicking RSM. I set the range of lower and upper limit of each factor unless "fixed factors" as you can see below and added some interaction terms. Then I made the design without having center points/ replicates with I-optimality, which created 15 treatments by default.Most of the values generate...
BJK_JerseyBoy

Discussions |
Sep 21, 2022 6:53 AM

2784 views | 9 replies
Multivariate Process Monitoring with MDMVCC

hi, I have been using the Model Drive Multivariate Control Charts for my process monitoring for a few months and there are a few questions / issues I would like to check if anyone has encountered similar, any solution available 1. Very often the model is sensitive to deviations from the baseline but still within normal operating range and is flagged up in the T2 plot. It would be great if a weight...
YelloBnn

Discussions |
Sep 21, 2022 6:26 AM

1189 views | 3 replies
can i block runs in a DOE after the experiments are run?

Hello, i am wondering if it is possible to group runs into blocks after i have run all experiments in a DOE. i would do this in the case that i can't control how many runs i am able to do per day (maybe due to random equipment downtime or other uncontrollable factors), and i would like to group runs done in a single day into blocks. typically, it seems like runs are grouped into blocks at the p...
LogitPorcupine1

Discussions |
Sep 21, 2022 5:15 AM

1908 views | 6 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

414 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

485 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

565 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

573 views | 0 replies