JMP User Community

Latest Discussions

The task scheduler in windows never stop running my script.

Hi allI have made a script to daily report a Html file. I am using Task scheduler in windows 10 to run the jsl every day. I haveto Action: "C:\Program Files\SAS\....\14\jmp.exe", location: "C:\....\myscript.jsl"I have closed all tables in the script and put Quit("no save"); at the end, but the job is running for ever with no result and stopping.Has any one a solution or any clue? Thanks
Mikasa

Discussions |
Mar 17, 2022 2:23 AM

24909 views | 18 replies
Column Missing after Join 2 data tables into 1 merge data table using scripting

Hi, I want to join 2 data tables into 1 merge data table using scripting. I already joint the 2 data tables into 1 joint data table manually, so I copied the same script from the joint data table into my master script. Somehow, when I run the master script, all the chosen columns from dt2 not included in the joint data table. Why it is not working? Data Table( "AVIYield (Datasheet)" ) << Join(...
WebDesignesCrow

Discussions |
Mar 17, 2022 1:29 AM

1753 views | 2 replies
Col list box dependence

Hi all, I have tabulated tables where users are free to choose the headers they need. In line with that, I have three col list boxes where users will chose the headers for the table. What I need to do is to make the two col box list dependent on the first one because the data to be manipulated will be based on the first col list box. Im not sure how to use On Change() on col list box, but is there...
UserID16644

Discussions |
Mar 17, 2022 1:08 AM

857 views | 1 replies
Automatically update "source" file

I have an excel file containing large database. I have exported this excel file into JMP to analyze and get insights into the data. The excel file is updated every hour with new sets of data. Every time the excel file gets updated, I've to click on the "source" file in JMP to update the table, and copy paste template scripts. My question: is there a way to automatically update the data in JMP tab...
JKS

Discussions |
Mar 16, 2022 7:06 PM

4752 views | 3 replies
Can continuous numerical variables with poor adjustability in practice be set as discrete numerical variables

Can continuous numerical variables with poor adjustability in practice be set as discrete numerical variables? Because when using the optimal experimental design, the factors given in the design table are not integers, but some parameters can only be controlled as integer values in the experimental process
BagOfKangaroo62

Discussions |
Mar 16, 2022 7:02 PM

1322 views | 3 replies

Previous
Next

Latest Discussions

Col list box dependence

Hi all, I have tabulated tables where users are free to choose the headers they need. In line with that, I have three col list boxes where users will chose the headers for the table. What I need to do is to make the two col box list dependent on the first one because the data to be manipulated will be based on the first col list box. Im not sure how to use On Change() on col list box, but is there...
UserID16644

Discussions |
Mar 17, 2022 1:08 AM

857 views | 1 replies
Can continuous numerical variables with poor adjustability in practice be set as discrete numerical variables

Can continuous numerical variables with poor adjustability in practice be set as discrete numerical variables? Because when using the optimal experimental design, the factors given in the design table are not integers, but some parameters can only be controlled as integer values in the experimental process
BagOfKangaroo62

Discussions |
Mar 16, 2022 7:02 PM

1322 views | 3 replies
Creating repeatable views for DoE Analysis

I'm noticing a few things in JMP14 that are different from my prior experience. Please advise if there is a way to create settings that I can use across my analyses.1. The prediction profiler is not reflecting the values in the columns. I have to manually change the range displayed. I have tried changing and saving to columns but this doesn't seem to make anything change as when I run another anal...
Alittle

Discussions |
Mar 16, 2022 11:05 AM

852 views | 1 replies
First Time User - Custom DoE

Hello, I have done design of experiments before, but pretty standard ones (screening design, full factorial). I have never used JMP before and never attempted at trying my hand at a custom design. I was hoping I could get some input as to the viability of the custom DoE I have created. I have 4 factors (time, temperature, amount of catalyst, solvent) plus one co-variate factor (water content...
Tehol

Discussions |
Mar 16, 2022 6:46 AM

2182 views | 4 replies
Cannot set value from list a variable

Dear all, I try to do scripting, but find difficulty and need your help para ={"align_ratio_2","align_ratio_1","minchaseforcef_3","maxchaseholdforce_4"}; 1) U1L1_MEAN[1] = Col MEAN(TCB1L_U1:para[1]); 2) U1L1_MEAN[1] = Col MEAN(TCB1L_U1:align_ratio_2);
There are different outputs between 1 and 2. For further checking, the output from 2 is correct.
Can anyone help me how to correct statement 1

Since...
PhamBao

Discussions |
Mar 15, 2022 8:56 PM

845 views | 1 replies

Previous
Next

Latest Discussions

No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

618 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

798 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

610 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1415 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

815 views | 0 replies