JMP User Community

Latest Discussions

JMP Scripting Noob: How to input a new column based on filtering data from two columns?

Hi all, I love JMP for it's graph building tools, so I am just starting to dabble in the scripting portion of it. Can someone help me with this request?I have two cols. One for X coordinate and one for Y coordinate. All I want to do is simply create a new col that will list Upper Right/Upper Left/Lower Right/Lower Left (LL) based on the X and Y Coordinate...So for example...if 0<X<5 and 0<Y<5, la...
schou1994

Discussions |
Feb 7, 2021 11:25 AM

1822 views | 2 replies
How to customized graph builder customized label display

Hi, By default when i show the label on graph builder, it show all data that used on X-axis, Y-axis and row. Can i customized the label only show what i want. I don't want to many unnecessary information on the info box. Please advise. Thanks eg. I only want yield and another item (wafer) that i choose.
OneNorthJMP

Discussions |
Feb 7, 2021 7:27 AM

2049 views | 2 replies
Need help converting a date format from character to numeric in JMP 15

Hi, My Excel sheet has the date format as: Wednesday, November 18, 2020, 12:45:00 PM. Upon importing into JMP 15, it is read as a character. Can you please share a method to convert the date from its character format to a numeric-continuous format (e.g., yyyy-mm-dd hh:mm)? I have attached a JMP file for your reference.Is there is a way to apply the correct (numeric) date format during import?Thank...
sumit_dutta

Discussions |
Feb 6, 2021 8:18 AM

2047 views | 2 replies
Alternative to "Select duplicate rows"

Hey guys,
I'm looking for an alternative to the "Select duplicate rows" function that does not exist in JMP12.
My aim is to delete duplicate rows by column value, with an exception of specific valueFor example, if I have this my data table, I want to leave the first substances of column "Color", With an exception that if the "Color" column value is Yellow, leave all these rows and don't delete them...
Stas

Discussions |
Feb 6, 2021 5:09 AM

1702 views | 3 replies
Mise en tableau des données

Bonjour,lorsque on fait une mise en tableau des données, peut-on mettre intitule d'une colonne sur deux ligne lorsqu'il est trop long.Si oui commentMerci
GPL12

Discussions |
Feb 5, 2021 10:19 PM

1152 views | 2 replies

Previous
Next

Latest Discussions

How to customized graph builder customized label display

Hi, By default when i show the label on graph builder, it show all data that used on X-axis, Y-axis and row. Can i customized the label only show what i want. I don't want to many unnecessary information on the info box. Please advise. Thanks eg. I only want yield and another item (wafer) that i choose.
OneNorthJMP

Discussions |
Feb 7, 2021 7:27 AM

2049 views | 2 replies
Need help converting a date format from character to numeric in JMP 15

Hi, My Excel sheet has the date format as: Wednesday, November 18, 2020, 12:45:00 PM. Upon importing into JMP 15, it is read as a character. Can you please share a method to convert the date from its character format to a numeric-continuous format (e.g., yyyy-mm-dd hh:mm)? I have attached a JMP file for your reference.Is there is a way to apply the correct (numeric) date format during import?Thank...
sumit_dutta

Discussions |
Feb 6, 2021 8:18 AM

2047 views | 2 replies
Alternative to "Select duplicate rows"

Hey guys,
I'm looking for an alternative to the "Select duplicate rows" function that does not exist in JMP12.
My aim is to delete duplicate rows by column value, with an exception of specific valueFor example, if I have this my data table, I want to leave the first substances of column "Color", With an exception that if the "Color" column value is Yellow, leave all these rows and don't delete them...
Stas

Discussions |
Feb 6, 2021 5:09 AM

1702 views | 3 replies
Mise en tableau des données

Bonjour,lorsque on fait une mise en tableau des données, peut-on mettre intitule d'une colonne sur deux ligne lorsqu'il est trop long.Si oui commentMerci
GPL12

Discussions |
Feb 5, 2021 10:19 PM

1152 views | 2 replies
If select where does not find value then do x else continue with rest of script

Hello and Happy Friday, I am trying to find a way around this one. I have a part in my script where it uses the following below. The issue I have is when it does not find the value ABC in Column1. Basically, I want it to where it runs the code below but if it does not find ABC, then I want it to save a blank table (csv) and stop running the rest of the code. If it does find ABC , then I want it ...
Josee

Discussions |
Feb 5, 2021 12:39 PM

884 views | 1 replies

Previous
Next

Latest Discussions

generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1009 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1275 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

3675 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1519 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1325 views | 0 replies