JMP User Community

Latest Discussions

How do I view the script after Standardize date format of date column in data tables?

Hello, I'm working on joining 2 data tables (import from Excel) to JMP to be only 1 table by using scripting. End result is I would like to build an automated report (.html) with running dates (increase) on x-axis. Since the format of the dates is not same between 2 data table after import from Excel (1 is text, another 1 is numeric), my graph not sorted correctly. I've standardized the dates colu...
WebDesignesCrow

Discussions |
Mar 13, 2022 11:14 PM

2258 views | 3 replies
How to let JMP give me a calculated (simplified) prediction equation (with coefficients calculated already)?

When I do a full factorial DOE, and get my model (variables are E and M, y is response). When I let the model "show prediction expression", it gives me a equation like this: y=This is a not finished equation, it need you to calculate and simplify it further. I don't know why JMP do this weird things like this since for a statistic software, to give a final simplified equation is not a difficult...
Leehappyjourney

Discussions |
Mar 13, 2022 5:55 PM

2887 views | 5 replies
How to interpolate curves

How to interpolate curve 1 (with sparse points) to match the number of points in curve 2 in order to do further calculations.
SymS

Discussions |
Mar 13, 2022 3:44 AM

2363 views | 2 replies
How to add New Rows in Conditional Match jmp 15

Hello,Is it possible to automatically add new matches to the formula?My data contains a Conditional Match Formula to group data.I.E. the data includes Rows like PartA-V1, PartA-V2, PartA-V3 and PartB-V1, PartB-V2, PartB-V3 that the matches would be PartA or PartB since the -V does not change what I am looking for. The actual data is has more complicated descriptions. The original data had ≈50 Ma...
Elby

Discussions |
Mar 12, 2022 9:46 AM

829 views | 1 replies
How to get only "Cp" value for a column in a Datatable?

Hi, I would like to get Cp value for a column in my data table to use it in multiple script location to tabulate it. With the available function "obj << Process Capability( LSL( 5 ), Target( 40 ), USL( 75 ) );" it is clear that we can get all process capability parameters in a plot. However i would like to get Cp value for a column and assign it to a variable in my script to use it in multiple sc...
AlexR846

Discussions |
Mar 12, 2022 12:00 AM

3146 views | 8 replies

Previous
Next

Latest Discussions

How to interpolate curves

How to interpolate curve 1 (with sparse points) to match the number of points in curve 2 in order to do further calculations.
SymS

Discussions |
Mar 13, 2022 3:44 AM

2363 views | 2 replies
How to add New Rows in Conditional Match jmp 15

Hello,Is it possible to automatically add new matches to the formula?My data contains a Conditional Match Formula to group data.I.E. the data includes Rows like PartA-V1, PartA-V2, PartA-V3 and PartB-V1, PartB-V2, PartB-V3 that the matches would be PartA or PartB since the -V does not change what I am looking for. The actual data is has more complicated descriptions. The original data had ≈50 Ma...
Elby

Discussions |
Mar 12, 2022 9:46 AM

829 views | 1 replies
How is power calculated in optimal designs?

How is power calculated in optimal designs? I designed a D-optimal split-split plot experiment, and as in classical split-split-plot designs, the power associated with the main plots and subplots are lower than the sub-sub plots, but I struggle to understand if power (and effect size) calculations in optimal designs are computed the same way as classical designs. In other words, how does applying ...
elb89

Discussions |
Mar 11, 2022 9:55 AM

870 views | 1 replies
Manage spec limits will not accept -/- or +/+ tolerances when using JSL

Hi all I made a nice script importing text files from my Zeiss CMM and adding Spec limits to each results column, it uses Manage spec limitsbut my script will not accept -/- or +/+ tolerances when using JSL, because a warning box pops up.So no tolerances are added to my columns, when I retry manually I can accept the import Thanks Jakob
Jakob

Discussions |
Mar 11, 2022 6:36 AM

796 views | 1 replies
How to Create a Fit Model with Different Sized Data Tables

I have 12 serialized assemblies. Each assembly has 8 parts, each part has a set of data of the same column structure. Each assembly goes through 1 qualification test.Each assembly then goes through 10 rounds of life testing (each round has the same column structure). That leaves me with 3 tables Table 1 has 8 rows per assemblyTable 2 has 1 row per assemblyTable 3 has 10 rows per assembly I am inte...
Phigene

Discussions |
Mar 10, 2022 3:26 AM

1392 views | 2 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

613 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

795 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

607 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

1409 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

814 views | 0 replies