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 EXP1...
CriticalMarten1

Discussions |
Oct 13, 2023 8:05 AM

406 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 ) Explode Lateral View
hogi

Discussions |
Oct 13, 2023 6:58 AM

718 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 resolv...
vharibal

Discussions |
Oct 13, 2023 2:49 AM

500 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 t...
MedianRooster10

Discussions |
Oct 13, 2023 2:05 AM

787 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 spe...
Andeka

Discussions |
Oct 13, 2023 1:55 AM

535 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 ...
FactorBiasFawn3

Discussions |
Oct 12, 2023 9:51 PM

345 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. How...
aadecarlojr

Discussions |
Oct 12, 2023 7:32 AM

535 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 poin...
belikin23

Discussions |
Oct 12, 2023 4:30 AM

868 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 w...
chandankishor66

Discussions |
Oct 12, 2023 1:43 AM

300 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 wor...
UserID16644

Discussions |
Oct 11, 2023 6:28 PM

338 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. ...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

286 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 mom...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

385 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 cre...
jthi

Discussions |
Sep 21, 2023 9:44 AM

280 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

383 views | 0 replies
Data Access Handler

...erformance of code (https://community.jmp.com/t5/Discussions/Differentiate-between-entire-column-and-current-row/m-p/677701/highlight/true#M86401) - to bugfix my code - to find out more about the nuts and b...
hogi

Discussions |
Sep 16, 2023 12:21 AM

239 views | 0 replies