JMP User Community

Latest Discussions

How can I split text in a column into multiple columns?

Sometimes I have a data set with information in one column that I would like split across multiple columns. For example in image 1 below I have four identifiers mashed into one column that I would like split into four columns. I want the lot number (11) text identifier (DAT) sample number (001,002 etc) and file type (.tif) all split into individual columns (as shown in image 2). What is the best w...
tpinck27

Discussions |
Dec 9, 2021 11:36 AM

60459 views | 17 replies
How do modify markers into lines/curves similar to excel

Hello,
I am creating the following plots via Graph builder and I was wondering if it would allow me to modify some markers into lines. FOr instance c1 solid blue lower triange -> SOlid Blue line. c2 hollow blue lower triange -> Dashed Blue line. c3 solid green circle-> SOlid green line. c4 solid red upper triangle-> SOlid Redline. c5 hollow red upper triangle-> Dashed Red line. The gray circles ...
skrishnan

Discussions |
Dec 9, 2021 9:52 AM

1304 views | 2 replies
Can JSL restore the value of the curve?

If already have a given curve, How can use code to restore close to the data.
Set the number of known data, and the maximum and minimum values of data
It seems to have some artificial intelligence function. Thanks Experts!
lwx228

Discussions |
Dec 9, 2021 3:49 AM

3005 views | 5 replies
Copy Cell value to column name and to spec limits

Hi All I have i challenge i need to coly the values of the cell in rownumber 8 to the column name for a lot of collums is there an easy way to script this. My next issue is that i have spec limits both low and high including Sepc units in 3 diffe rows is there a way to script this to the Spec limits om the column
Claus_Jensen

Discussions |
Dec 9, 2021 3:43 AM

1001 views | 1 replies
I/O Problem. Unable to open in ReadWrite mode

Every time I try to save something I'm working on jump this mesage shows up. Also, I can't open figures other people do on the project we share and the folders I have download in the past week to the project are also gone. How can I solve this problem? Reinstalling would help?
AliceT

Discussions |
Dec 8, 2021 2:46 PM

921 views | 0 replies

Previous
Next

Latest Discussions

How do modify markers into lines/curves similar to excel

Hello,
I am creating the following plots via Graph builder and I was wondering if it would allow me to modify some markers into lines. FOr instance c1 solid blue lower triange -> SOlid Blue line. c2 hollow blue lower triange -> Dashed Blue line. c3 solid green circle-> SOlid green line. c4 solid red upper triangle-> SOlid Redline. c5 hollow red upper triangle-> Dashed Red line. The gray circles ...
skrishnan

Discussions |
Dec 9, 2021 9:52 AM

1304 views | 2 replies
I/O Problem. Unable to open in ReadWrite mode

Every time I try to save something I'm working on jump this mesage shows up. Also, I can't open figures other people do on the project we share and the folders I have download in the past week to the project are also gone. How can I solve this problem? Reinstalling would help?
AliceT

Discussions |
Dec 8, 2021 2:46 PM

921 views | 0 replies
Refresh Excel SQL quarry before extracting data to JMP

Hi,Just wondering if there is a way to use JMP scripting to refresh data in the Excel workbook before it is being imported to JMP table.I can't build direct query from JMP to the database because there is too many obstacles like very old and not updatable Acces database on very old tool and differences in bitnes between office and JMP, but I can extract data from the Excel whchi has build in SQL q...
swiergi11

Discussions |
Dec 8, 2021 7:40 AM

925 views | 1 replies
How to set "characters" as "missing values"?

My table on JMP has a column that contains both numbers and characters. The table lists down products, and this column records the minimum requirement for a specific performance test. Therefore, the cells of the columns could store one of the three:- a numerical value;- "N/A" when the test is not required to be performed on a specific product (entry);- two alternative numerical value (e.g. 4.5 if....
SaraGo

Discussions |
Dec 8, 2021 7:37 AM

1486 views | 1 replies
How to calculate TF-IDF

Dear all, I am new to using this software and am struggling to figure out how to use it to calculate the TF-IDF values for documents in my data set. I am sure it is included in the functionality of JMP but it must be under a different name. Would anyone be able to point me in the right direction? ThanksMark
markw

Discussions |
Dec 8, 2021 7:20 AM

4918 views | 11 replies

Previous
Next

Latest Discussions

I/O Problem. Unable to open in ReadWrite mode

Every time I try to save something I'm working on jump this mesage shows up. Also, I can't open figures other people do on the project we share and the folders I have download in the past week to the project are also gone. How can I solve this problem? Reinstalling would help?
AliceT

Discussions |
Dec 8, 2021 2:46 PM

921 views | 0 replies
Permutation Tests and Monte Carlo Cross Validations Using the Simulation Platform

I'm trying to do permutation tests and Monte Carlo Cross Validations with the Iris sample dataset as a MWE for our dataset. I'm not sure if I'm doing things and interpreting output correctly. 1) Create New Formula Column (Random->Sample Without Replacement) for the Species Column for Permutation Test. 2) Create a Validation Column (0.75/0.25 split) and a new Formula Column (Random->Sample Withou...
mjmg

Discussions |
Dec 1, 2021 7:53 AM

893 views | 0 replies
Content Mentions Demo

@IanAtJMP wrote the article Notification Settings: An Overview and here are some keywords from a post Images in Notification Emails
jmp_demo

Discussions |
Nov 22, 2021 8:01 AM

637 views | 0 replies
DoE with two-choice experiments, continuous response variable

We want to rank the preference of population of animals for n different recipes. Recipes are tested in two-choice assays, where groups of over 100 individuals can choose one choice or the other. Preference for the group is computed as a preference index, a continuous variable that is between -1 and 1. Is there an experimental design that would help reduce the number of combinations to test in ord...
Alexa_Guigue

Discussions |
Nov 19, 2021 7:06 AM

730 views | 0 replies
Can I share dashboard with specific person in JMP Public?

Hi, I would like to share my dashboard in JMP Public. However, there are only two choices: "only share with me" and "share with everyone". Is there anyway to share with specific persons? Thanks.
lujc07

Discussions |
Nov 9, 2021 7:41 AM

743 views | 0 replies