JMP User Community

Latest Discussions

Syntax error with "function" or "for"

Hello JMPers, My (JMP 14.3.0, W10) intention is to write a function that takes a table (dt) and list of unique Lot Numbers (uids) as input, and construct a table by concatenating a copy of dt for each uid, and filling in the appropriate Lot. No. information for each of those spots. The purpose of this is so I can later do join operations on the table. I am in the early part of the JSL learning cur...
ScottMullin

Discussions |
Oct 9, 2023 6:51 PM

2247 views | 1 replies
import images in xls to jmp

Hi, I have a data table in xls which I would like to import to jmp. This data table from a patent search engine is containing a column with a link to the patent pdf and a column with an images from the first page of the patent. I do not manage to get those 2 columns (even as expressions ) into a jmp table.Thanks SC
StevenC

Discussions |
Oct 9, 2023 6:27 PM

943 views | 1 replies
How to run multiple "update from database" table scripts run at once without deleting columns?

Hello! I have a data table that was produced via a script running two separate queries (that provide data from two different sources) which are then merged to form a data table. My question is with regards to updating this table daily in a way that the script doesn't need to be re-run from the start and any cleaning/adjustments/new columns can be kept. I see on the side bar there is both an "updat...
Jaiyce_x

Discussions |
Oct 9, 2023 3:01 PM

1424 views | 1 replies
Fitting Non-linear curve for selected data.

Instead of using the data columns directly from the data table, I wanted to you to use the columns that are selected by the user. But the values are not getting passed into the formula. Y_axis = colListY << Get Items; X_axis = colListX << Get Items; Group_by = colListBy << Get Items; New Column( "Model", Numeric, "Continuous", Format( "Best", 12 ), Formula( Parameter(...
Vinusha

Discussions |
Oct 9, 2023 1:46 PM

5736 views | 8 replies
How do I calculate 10, 50, 90% of a cumulative curve in JMP?

I have column with certain sizes, and the percentage of how often they occur.
Through the cumulative curve I would then like to extract the size that matches the 10, 50 and 90% threshold, but cannot do so linear.The Savitzky-Golay smoother describes my data best.I have included a screenshot of both my columns and my graph for better understanding.
vaesenjonas

Discussions |
Oct 9, 2023 1:35 PM

1824 views | 2 replies

Previous
Next

Latest Discussions

Syntax error with "function" or "for"

Hello JMPers, My (JMP 14.3.0, W10) intention is to write a function that takes a table (dt) and list of unique Lot Numbers (uids) as input, and construct a table by concatenating a copy of dt for each uid, and filling in the appropriate Lot. No. information for each of those spots. The purpose of this is so I can later do join operations on the table. I am in the early part of the JSL learning cur...
ScottMullin

Discussions |
Oct 9, 2023 6:51 PM

2247 views | 1 replies
import images in xls to jmp

Hi, I have a data table in xls which I would like to import to jmp. This data table from a patent search engine is containing a column with a link to the patent pdf and a column with an images from the first page of the patent. I do not manage to get those 2 columns (even as expressions ) into a jmp table.Thanks SC
StevenC

Discussions |
Oct 9, 2023 6:27 PM

943 views | 1 replies
How to run multiple "update from database" table scripts run at once without deleting columns?

Hello! I have a data table that was produced via a script running two separate queries (that provide data from two different sources) which are then merged to form a data table. My question is with regards to updating this table daily in a way that the script doesn't need to be re-run from the start and any cleaning/adjustments/new columns can be kept. I see on the side bar there is both an "updat...
Jaiyce_x

Discussions |
Oct 9, 2023 3:01 PM

1424 views | 1 replies
Fitting Non-linear curve for selected data.

Instead of using the data columns directly from the data table, I wanted to you to use the columns that are selected by the user. But the values are not getting passed into the formula. Y_axis = colListY << Get Items; X_axis = colListX << Get Items; Group_by = colListBy << Get Items; New Column( "Model", Numeric, "Continuous", Format( "Best", 12 ), Formula( Parameter(...
Vinusha

Discussions |
Oct 9, 2023 1:46 PM

5736 views | 8 replies
How do I calculate 10, 50, 90% of a cumulative curve in JMP?

I have column with certain sizes, and the percentage of how often they occur.
Through the cumulative curve I would then like to extract the size that matches the 10, 50 and 90% threshold, but cannot do so linear.The Savitzky-Golay smoother describes my data best.I have included a screenshot of both my columns and my graph for better understanding.
vaesenjonas

Discussions |
Oct 9, 2023 1:35 PM

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

618 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

1124 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

848 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