JMP User Community

Latest Discussions

Update column value from another table using wildcard

Hi all, is it possible to update a column from values coming from another table using wildcard as key? I have this example table but doesn't know how to use wildcards properly in updating tables. Also, I am still using JMP 15 version Table AId_AModelStatusStart DateEnd Date23-ABC-AAADone2023-10-012023-10-0523-ABD-BBBDone2023-10-022023-10-0723-ACD-BBCOngoing2023-10-032023-10-09 Table B (file to be ...
UserID16644

Discussions |
Oct 9, 2023 9:40 PM

814 views | 2 replies
Format List Box text by value that naturally shows up when using the By clause in JSL

Hi all, I am trying to make an individual oneway chart based on the value in a given list. I am able to do it in a for loop using where column == value in list and so on. The issue is that when I use a where clause I get this TextBox in the Listbox above the chart that I am unable to change the text of through JSL. I am able to change it when I right click and go into the properties but I want th...
neelsrejan

Discussions |
Oct 9, 2023 8:55 PM

1096 views | 1 replies
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

942 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

Previous
Next

Latest Discussions

Update column value from another table using wildcard

Hi all, is it possible to update a column from values coming from another table using wildcard as key? I have this example table but doesn't know how to use wildcards properly in updating tables. Also, I am still using JMP 15 version Table AId_AModelStatusStart DateEnd Date23-ABC-AAADone2023-10-012023-10-0523-ABD-BBBDone2023-10-022023-10-0723-ACD-BBCOngoing2023-10-032023-10-09 Table B (file to be ...
UserID16644

Discussions |
Oct 9, 2023 9:40 PM

814 views | 2 replies
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

942 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

5735 views | 8 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

847 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