JMP User Community

Latest Discussions

Update table according to the date less than or equal to the reference file

Hi all, I have 2 tables where the dtA is my original file and dtB is my reference file. What I would wanted to do is to have dtA be updated according to the date less than or equal to the reference file.For example, Table dtADate ModelQty06/24/2023A2306/30/2023A2507/01/2023A3407/05/2023A50 Table dtBDate ModelRef06/01/2023A10007/01/2023A150 After updating dtA, the table should look like thisDate Mo...
UserID16644

Discussions |
Oct 1, 2023 7:51 PM

2341 views | 7 replies
Automatic recalc

Hello! Been using JMP to create automation for data processing and reports. One of my scripts is not working when I upgraded to JMP16. Already checked it on JMP15 and its not having this problem there.The problem is the automatic recalc in several of my plot functions. It gives me this error message: I already tried putting this line: "rbiv = biv << report;" before the marker size command line but...
Zelda

Discussions |
Oct 1, 2023 7:15 PM

869 views | 1 replies
Some proxied HTTP requests fail on Windows (schannel: next InitializeSecurityContext failed)

Hello, we've found that some HTTP requests (specifically to AWS S3) fail with an HTTP proxy on Windows with the error: schannel: next InitializeSecurityContext failed: Unknown error (0x80092012) It looks like this may be related to these curl issues:https://github.com/curl/curl/issues/3727https://github.com/curl/curl/issues/4078 Do you have any suggestions for how to resolve or work around this is...
OmegaMonster183

Discussions |
Oct 1, 2023 5:55 PM

3018 views | 2 replies
Filter the most frequent value in multiple columns

Hi everyone, My goal is to select only the rows that have the most common values (character type) in each column. For instance, my table has four columns: A, B, C, and D. The values that appear the most in columns A, B, C, and D are A1, B2, C3, and D4, respectively. How can I write a JSL code that filters the rows by these values and creates a new table with the filtered data? Thank you. Thanks
Dzungtran

Discussions |
Sep 29, 2023 11:47 PM

1290 views | 2 replies
date differences in two datasets

Hi, I have two datasets on a cohort of patients. One has dates of test “a” and the other has dates of test “b”. the number of tests a and b on a subject vary (i.e., some have a lot of a and few b or visa versa) I need to find all instances where tests a and b are within a timeframe (90 days for this project). How could I automate the comparison of all combinations of test a and b to find the te...
jsolo01

Discussions |
Sep 29, 2023 11:41 PM

2416 views | 7 replies

Previous
Next

Latest Discussions

Automatic recalc

Hello! Been using JMP to create automation for data processing and reports. One of my scripts is not working when I upgraded to JMP16. Already checked it on JMP15 and its not having this problem there.The problem is the automatic recalc in several of my plot functions. It gives me this error message: I already tried putting this line: "rbiv = biv << report;" before the marker size command line but...
Zelda

Discussions |
Oct 1, 2023 7:15 PM

869 views | 1 replies
Some proxied HTTP requests fail on Windows (schannel: next InitializeSecurityContext failed)

Hello, we've found that some HTTP requests (specifically to AWS S3) fail with an HTTP proxy on Windows with the error: schannel: next InitializeSecurityContext failed: Unknown error (0x80092012) It looks like this may be related to these curl issues:https://github.com/curl/curl/issues/3727https://github.com/curl/curl/issues/4078 Do you have any suggestions for how to resolve or work around this is...
OmegaMonster183

Discussions |
Oct 1, 2023 5:55 PM

3018 views | 2 replies
date differences in two datasets

Hi, I have two datasets on a cohort of patients. One has dates of test “a” and the other has dates of test “b”. the number of tests a and b on a subject vary (i.e., some have a lot of a and few b or visa versa) I need to find all instances where tests a and b are within a timeframe (90 days for this project). How could I automate the comparison of all combinations of test a and b to find the te...
jsolo01

Discussions |
Sep 29, 2023 11:41 PM

2416 views | 7 replies
Does JMP label the centroid in a mixture design?

Center points in small design spaces can often be identified in the data table by inspection. This becomes much more difficult for mixture designs with large numbers of components (>=5), especially when linear constraints are superimposed. When design points match classical designations (e.g., vertices, centroids, binary double blends, axial check points, etc.), does JMP have the ability to lab...
wvknowles

Discussions |
Sep 29, 2023 7:18 PM

990 views | 2 replies
Can I save each page of a graph(from graph builder) into one separate image file?

I generated lots of pages from one graph. This is from graph builder. I like to save each page as one image file. Is this possible in JMP? Thanks,
Dave
davidmingyin

Discussions |
Sep 29, 2023 9:35 AM

3745 views | 6 replies

Previous
Next

Latest Discussions

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
Use JMP Locale Settings( 0 ) not working on macOS

It seems the following command does not work for JMP MacOS. Use JMP Locale Settings( 0 ) Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...
FN

Discussions |
Sep 15, 2023 10:21 AM

674 views | 0 replies
Inherited Plot settings

Hi,
I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

One example:
If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...
hogi

Discussions |
Sep 14, 2023 11:11 PM

654 views | 0 replies