JMP User Community

Latest Discussions

Change column format

Hi all, I am opening a csv file with dates (0000-00-00) having a default column data type character. However, whenever I tried to update the column with a formula from another column with a date value, I cannot change the format into date. My code looks something like thisdt = Open ("C:\Users\table1.jmp"); dt2 = Open ("C:\Users\table1.jmp"); dt2 << Update( With( dt), Match Columns( :idFin = :idF...
UserID16644

Discussions |
Oct 10, 2023 6:06 PM

1136 views | 1 replies
How to create a two column user input modal window where the second column is populated based on single input on first column?

I would like to create a two column user input modal window where the user input goes into the first column (single input box) for a "parent part ID", based on which adjacent second column window entries (child part IDs) get populated.The entries in the second column come from a database query (for which I already have a script). A "parent part ID" can have one or more than one "child part IDs"Thi...
Neo

Discussions |
Oct 10, 2023 9:10 AM

7564 views | 21 replies
How to screen easily the non significant of many factors(~200 columns) before to perform a mulitple regression.

I have many factor (~200 columns) and one response,i have many measures.Most of this factors show colinearity between them,is there a simple way to perform a first filter of the not relevant factors?Then in the remaining i will perform a multiple regression.
Perpignan_italy

Discussions |
Oct 10, 2023 5:50 AM

1731 views | 3 replies
How can I find Custom Map Creator Add-In

I fail to find where is Custom Map Creator. I do not know how to open it.
WhiskyNing

Discussions |
Oct 10, 2023 12:22 AM

1041 views | 2 replies
How do replace these with JSL with regex substitution?

This is copied in the browser. How to use JSL's regular substitution is processed into syntactic JSL with the following requirements:
1, contains POST......HTTP/1.1 replaced with: u="...";h=[=>];
2, containing:, write h
3. The last line..., replace with: jj="...";rs=New HTTP Request(URL(u),Method("POST"),JSON(jj),Headers(h));Thanks! POST https://app.com/w1/api HTTP/1.1 Host: apparticle.longhuvip.com...
lala

Discussions |
Oct 10, 2023 12:02 AM

3421 views | 11 replies

Previous
Next

Latest Discussions

How to screen easily the non significant of many factors(~200 columns) before to perform a mulitple regression.

I have many factor (~200 columns) and one response,i have many measures.Most of this factors show colinearity between them,is there a simple way to perform a first filter of the not relevant factors?Then in the remaining i will perform a multiple regression.
Perpignan_italy

Discussions |
Oct 10, 2023 5:50 AM

1731 views | 3 replies
How can I find Custom Map Creator Add-In

I fail to find where is Custom Map Creator. I do not know how to open it.
WhiskyNing

Discussions |
Oct 10, 2023 12:22 AM

1041 views | 2 replies
How do replace these with JSL with regex substitution?

This is copied in the browser. How to use JSL's regular substitution is processed into syntactic JSL with the following requirements:
1, contains POST......HTTP/1.1 replaced with: u="...";h=[=>];
2, containing:, write h
3. The last line..., replace with: jj="...";rs=New HTTP Request(URL(u),Method("POST"),JSON(jj),Headers(h));Thanks! POST https://app.com/w1/api HTTP/1.1 Host: apparticle.longhuvip.com...
lala

Discussions |
Oct 10, 2023 12:02 AM

3421 views | 11 replies
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

800 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

2231 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

610 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

1111 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

729 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

840 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

556 views | 0 replies