JMP User Community

Latest Discussions

Using variables in column formulas

I want to change all references to "AGC EXP101P 2" to the variable 'colname' so that when I run the script this code applies to the selected column in the data table and not just the column "AGC EXP101P 2". However, when I try to change it, JMP always reads the variable name as a string in the column formula and doesn't evaluate properly. How do I fix this so that the column formula recognises the...
CriticalMarten1

Discussions |
Oct 13, 2023 8:05 AM

1107 views | 1 replies
Database access

Hi, when I generate a Database Query via the GUI in Jmp, how can I use advanced SQL functionality?SQL formulas (rand (),txt = Substring(), myValue = a+b )ExplodeLateral View
hogi

Discussions |
Oct 13, 2023 6:58 AM

1919 views | 4 replies
Delete object reference in SQL custom query - JMP 17

Hi,I am trying to query data base by providing input parameter through a variable. 1] I am seeing below error for attached:a = 666.1;
deleted object reference[] How do i resolve this? It works when I use 666.1 directly here FROM fer_view2 t1 where(t1.DVT_id = 666.1) a = 666.1; show(a); obj = New SQL Query( Connection( "ODBC:DSN=DVT Data Server" ), QueryName( "fer_view2" ), CustomSQL( "SELE...
vharibal

Discussions |
Oct 13, 2023 2:49 AM

1301 views | 2 replies
How can I make a graph from data in multiple data tables without physically joining the tables?

I have 2+ data tables with the same columns and I want to produce a graph using all the tables. Previously, I have concatenated them and used the resulting table however this produces lots of extra tables. Is there a way to essentially concatenate them without physically creating a new table?( Also, want to automate this process if possible.)
MedianRooster10

Discussions |
Oct 13, 2023 2:05 AM

2098 views | 3 replies
Control charts automatization with spec limits based on product

Dear community,I perform trend analyses using control charts for different products of the same family, which share common process controls (pH, manufacturing time...), but which have different specification limits. I would like to have just a column with common process control data (col 3 in example), and through a script apply the different spec limits by product ( i am currently using automatic...
Andeka

Discussions |
Oct 13, 2023 1:55 AM

1405 views | 1 replies

Previous
Next

Latest Discussions

Export Over 200 Graphs from Graph Builder

I am trying to display and/or export close to 900 graphs from a dataset using Graph Builder using JMP Pro 17.0.0 into a PowerPoint or pdf format. However, it seems like 200 graphs is the maximum JMP will display or export. Am I missing something to display/export them all or is there a preference I can toggle to allow more to be displayed/exported? Thanks!
FactorBiasFawn3

Discussions |
Oct 12, 2023 9:51 PM

801 views | 1 replies
analysis of fit to cosine wave

I am planning to analyze circadian rhythm data and can fit it to the Savitzky-Golan smoother with a cubic degree and local cosine weighting. This provides a visual with a confidence of fit. However, is there a way to statistically determine the quality of the fit to the cosine waveform? I have tried saving the smoother formula to the data table then launching the analysis using the upper and low...
aadecarlojr

Discussions |
Oct 12, 2023 7:32 AM

1585 views | 2 replies
Categorical heatmap?

I'm trying to find a way to combine the two wafer maps below. In other words, I need the X/Y coordinates to actually appear as rectangular die areas on a wafer, like in the heatmap below (not as points), AND have the legend to be discreet and maybe customized colors like in the point map below (not as a continuous gradient from 0-4). Is there any way to combine these features? TIA! Heatmap: Point...
belikin23

Discussions |
Oct 12, 2023 4:30 AM

2173 views | 5 replies
Adjust only the hour values in DD-MM-YY H:M:S

HI JMP users, I have a column that contains data in the format DD-MM-YY H:M:S (screenshot attached below), and I would like to adjust only the hour values to make them even. For example, I want to change a time like 13-07-2023 15:00 to 13-07-2023 16:00. Is there a method to modify only the hour values across the entire column? Regards,
chandankishor66

Discussions |
Oct 12, 2023 1:43 AM

880 views | 1 replies
Loop through dates

Hi All,I am trying pull some data from the database by looping through dates, in this example, I am trying to loop from June until the date yesterday. This is my sample code. However, it is not working. Can someone explain how to properly do it? TIA d = Today() - In Days(1); dateNow = Format (d, "m/d/y"); startdate = "2023-06-01"; For( i = startdate, i <= dateNow, i++, try( dt = Open Database( "...
UserID16644

Discussions |
Oct 11, 2023 6:28 PM

905 views | 1 replies

Previous
Next

Latest Discussions

Strange behavior using GenReg and Forward Selection

Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

617 views | 0 replies
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

1121 views | 0 replies
What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

733 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

845 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

560 views | 0 replies