JMP User Community

Latest Discussions

Opening a specific date range from SQL tables

I open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days. Here is my open table script:
Open Database(
"DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
"SELECT * FROM dbo.VisitLog", "VisitLog"
); The column I want...
JocelynJohnson

Discussions |
Nov 11, 2022 1:29 PM

1552 views | 1 replies
Regex Issure with Decimals and Whole Numbers

Hello! Using JMP 16.2: I have a column with whole numbers and decimal numbers. I want to create a new column that flags the whole numbers (or the decimals). Column Name: ValueColumn Inputs:0.533.76810etc. I have tried several versions of the following Regex using a column formula:Regex(Value,"\d+\,\d+", "Decimal")Regex(Char(Value),"\d+\,\d+", "Decimal")I have also tried parentheses and brackets t...
Maerawlings

Discussions |
Nov 11, 2022 10:11 AM

2239 views | 3 replies
How to add the date to file name while uploading a file to s3 bucket using alteryx

I have a workflow in alteryx where I am downloading two files from two different urls. After making the required modifications I want to upload them to the s3 bucket as well as save a copy locally. I want to add the current date while saving the file in both cases. I was successful in using a formula tool to rename the file saved locally. But unable to do for the copy being uploaded to s3. Can any...
pavanroast

Discussions |
Nov 11, 2022 3:03 AM

1029 views | 1 replies
Long time for big data

Hi, I'm using JMP for larger datasets, 1000 variables, and 500 subjects. It takes a long time, like a couple of minutes to run a simple fit model. I have a good laptop with 64G RAM, 4g GPU, and so on. When running JMP, nothing gets even close to 30% usage, still, it takes forever for JMP to do anything. I gave JMP Realtime priority. Any suggestions? Best Kamil
Kamil

Discussions |
Nov 10, 2022 3:02 PM

3833 views | 8 replies
GR&R method used by JMP

HiI would like to know the details of the GR&R method used by JMP. I have tried to replicate the JMP's results by writing a simple code in Python. I am assuming JMP is using ANOVA method (https://www.spcforexcel.com/knowledge/measurement-systems-analysis/anova-gage-rr-part-1) but, I never get the same results as JMP calculations. Could someone direct me to the related JMP documentation? Thank you
LoglinearRange8

Discussions |
Nov 10, 2022 10:17 AM

1676 views | 2 replies

Previous
Next

Latest Discussions

Opening a specific date range from SQL tables

I open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days. Here is my open table script:
Open Database(
"DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
"SELECT * FROM dbo.VisitLog", "VisitLog"
); The column I want...
JocelynJohnson

Discussions |
Nov 11, 2022 1:29 PM

1552 views | 1 replies
Regex Issure with Decimals and Whole Numbers

Hello! Using JMP 16.2: I have a column with whole numbers and decimal numbers. I want to create a new column that flags the whole numbers (or the decimals). Column Name: ValueColumn Inputs:0.533.76810etc. I have tried several versions of the following Regex using a column formula:Regex(Value,"\d+\,\d+", "Decimal")Regex(Char(Value),"\d+\,\d+", "Decimal")I have also tried parentheses and brackets t...
Maerawlings

Discussions |
Nov 11, 2022 10:11 AM

2239 views | 3 replies
How to add the date to file name while uploading a file to s3 bucket using alteryx

I have a workflow in alteryx where I am downloading two files from two different urls. After making the required modifications I want to upload them to the s3 bucket as well as save a copy locally. I want to add the current date while saving the file in both cases. I was successful in using a formula tool to rename the file saved locally. But unable to do for the copy being uploaded to s3. Can any...
pavanroast

Discussions |
Nov 11, 2022 3:03 AM

1029 views | 1 replies
GR&R method used by JMP

HiI would like to know the details of the GR&R method used by JMP. I have tried to replicate the JMP's results by writing a simple code in Python. I am assuming JMP is using ANOVA method (https://www.spcforexcel.com/knowledge/measurement-systems-analysis/anova-gage-rr-part-1) but, I never get the same results as JMP calculations. Could someone direct me to the related JMP documentation? Thank you
LoglinearRange8

Discussions |
Nov 10, 2022 10:17 AM

1676 views | 2 replies
Exploring data with ANCOVA

Hello, I have 3 independent variables, a continuous covariate (Mass), a categorical nominal variable (sex: M and F) and another categorical nominal variable (Site location: North, Middle, and South) and one dependent variable, continuous (mercury concentration). I am interested in testing the hypothesis " If the variation of mass and sex in an organism can be standardized (homogenized, accounted f...
IWRRI

Discussions |
Nov 10, 2022 6:39 AM

3277 views | 2 replies

Previous
Next

Latest Discussions

Linear mixed model not showing "Random Effect" noise in simulator/monte carlo

I have fit a Mixed Model via the Fit Model platform in JMP Pro. When opening up the 'Prediction Profiler', and inspecting the Profiler itself, I can see the as expected predicted response and its as expected confidence interval in [], which reflects the variation due to the Random Effects I have fit. However, when I run the 'Simulator' with equal experimental variables as above, and after adding ...
Vartian

Discussions |
Nov 8, 2022 5:38 AM

834 views | 0 replies
Monte Carlo / Simulator from Mixed Model not showing "Random Effect" noise

I have fit a Mixed Model via the Fit Model platform in JMP Pro. When opening up the 'Prediction Profiler', and inspecting the Profiler itself, I can see the as expected predicted response and its as expected confidence interval in [], which reflects the variation due to the Random Effects I have fit. However, when I run the 'Simulator' with equal experimental variables as above, and after adding n...
Vartian

Discussions |
Nov 4, 2022 12:48 PM

663 views | 0 replies
How do I save plots/images at a specific size when they are generated in a project?

Hi,when I generate images within a project the window size attribute is ignored (the plot is always maximized). How do I prevent this to define a specific image size, esp. when the plots are saved? Best regards,Ole @martindemel
OHS

Discussions |
Nov 4, 2022 6:53 AM

670 views | 0 replies
JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1167 views | 0 replies
How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...
SquaresDingo505

Discussions |
Oct 24, 2022 7:23 PM

719 views | 0 replies