JMP User Community

Latest Discussions

remove duplicate Columns

Hi: I have a hugue data table with 400+ columns and 50,000 rows. I have a 30-40 duplicate columns and I would like to remove them from my data table. any ideas?
KR

Discussions |
Jul 10, 2017 2:23 AM

7001 views | 5 replies
JMP for Machine Learning and Score Code Deployment

I would like to use JMP to speed up data analysis and creation of neural network prediction models. Our runtime environment would be using the Google Cloud Platform and TensorFlow. Can anyone point me to some good articles or videos about how to make the best use of JMP for that? My business must be excellent at creating models for customers quickly and efficiently. Would JMP be a tool that ca...
mikemalloy

Discussions |
Jul 9, 2017 7:35 AM

15574 views | 4 replies
List of expressions

I'd like to build up a list that looks like this. LL = {parm1 = "x", value1 = 5, parm2 = "y", value2 = 3, ...}The length may vary, so I'm doing it in a loop and trying to use the loop index in the variable name.But I am having difficulty creating that term (e.g. parm1).What is the best way to do this?
pcarroll1

Discussions |
Jul 7, 2017 12:26 PM

11306 views | 5 replies
How to use Number Edit Box new value

Hello everyone! I feel like such a novice today. I cannot seem to find clear information on how to have Number Edit Box values update a Window, other Number Edit Boxes, and equations when values are changed. My biggest issue is that I have over 30 Number Edit Boxes that feed 2 equations/formulas. Setting the starting values, I have down. If a value is changed, everything else needs to update ...
WendyLou315

Discussions |
Jul 7, 2017 10:41 AM

9093 views | 4 replies
How to Add Value Labels to a Column through JSL

On my main table (Table 1), I have a column called "Bin" which holds any number (corresponding to the column "Bin Number" entries on another table which is Table 2). Now I want to assign Value Labels to this column "Bin" through script. The value labels would be coming from Table 2 with two columns: "Bin Number" and "Description". Hard-coding something like Column( dt, 1 ) << Add Column Properti...
csoon1

Discussions |
Jul 7, 2017 9:54 AM

9500 views | 2 replies

Previous
Next

Latest Discussions

remove duplicate Columns

Hi: I have a hugue data table with 400+ columns and 50,000 rows. I have a 30-40 duplicate columns and I would like to remove them from my data table. any ideas?
KR

Discussions |
Jul 10, 2017 2:23 AM

7001 views | 5 replies
Replacing Values with Empty Value

I have a script that is based on an imported excel table. I do not have the ability to change anything in the Excel table and have to do all data manipulation and analysis through JMP. The point of the script is to calculate days between dates entered to track project phases. Some of the dates are importing incorrectly as 31Dec1899 based on the way the formula is set up in the Excel sheet and ther...
rfeick

Discussions |
Jul 7, 2017 8:02 AM

6132 views | 4 replies
How to rename the outline box default to "graph builder"

How do I rename the outline box on a graph builder that by default says "Graph Builder"
agonzales2021

Discussions |
Jul 6, 2017 7:58 AM

7197 views | 5 replies
Combine many strings into one.

Hi guys, I've a list as per below of string names. I want to concantanate the value of each string in the list, into one combined string. So the result of below would be a string who's value would be "This is a sentence". How would I code this ? Begining = "This"; Middle = "is a"; End = "sentence" StringList = {"Begining","Middle", "End"};
BrianK

Discussions |
Jul 4, 2017 11:03 AM

12712 views | 4 replies
Update existing table with new data without creating output table

Hi,I am trying to write a script that will update my existing table without producing an output table. I have the following code which doesn't seem to work:Data Table("Crea Table") << Update from Database("DRIVER=SQL Server Native Client 11.0;SERVER=REMOVED FOR SECURITY;", "EXECUTE Crea_Table" ,Merge Same Name Columns, By matching Columns(:Lot_Day=:Lot_Day,:Lot ID=:Lot ID), Drop Multiples(1,0),N...
joickle

Discussions |
Jun 30, 2017 4:54 PM

5175 views | 2 replies

Previous
Next

Latest Discussions

JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4565 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2279 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4522 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3426 views | 0 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3539 views | 0 replies