JMP User Community

Latest Discussions

Real-time data display

I'm wondering if JMP Pro has some instructions and capabilities that allow users to automatically run various scripts to pull data from a SQL database and update data displays (HTML or otherwise) at user specified frequencies? I've been digging through the various manuals and haven't found anything that indicates that this capability exists within JMP Pro. Am I trying to get JMP to do something ...
terapin

Discussions |
Nov 9, 2019 10:56 AM

7376 views | 8 replies
Combining multiple datasheets into one mastersheet - Can "Table Join" create with creating multiple columns" ?

Hello - I usually work with big datasets with multiple sheets provided in xls format.I usually prework those sheets in excel with pivot tables and match functions to combine the multiple lists into into one mastersheet , so that every individual row represents one individual case with multiple variables in columns. A sample is displayed here - ID as unique identifier - weight - [Code 101, Code 102...
marc1

Discussions |
Nov 9, 2019 7:36 AM

5050 views | 2 replies
How do I convert a timestamp to a duration format?

I would like to convert a column containing timestamp data in the numeric "ddMonyyyy h:m:s" time format to a numeric time duration format in seconds, starting the duration in the first row of my datatable.
WHG

Discussions |
Nov 8, 2019 5:10 AM

2231 views | 1 replies
Run saved scripts after a data table update

Hi, I saved a lot of scripts in a data table that I want to keep using after a major update of my data matrix, is this possible? How?Thanks for advice, Frank
frankderuyck

Discussions |
Nov 8, 2019 2:07 AM

3235 views | 4 replies
Increment a counter from 1 to n for every unique set of identical rows

Hi everyone, I figure what I want to do is really easy, I just haven't come up with a good way to do it. I have a large table with a substantial number of identical rows which I want to rename uniquely but in a reproducible way. Currently, I have a script that takes the following column: A number 1 B number 1 A number 2 A number 3 A number 3 A number 3 B number 3 B number 3 B number 3 ... In...
screech

Discussions |
Nov 7, 2019 11:58 AM

2891 views | 1 replies

Previous
Next

Latest Discussions

How do I convert a timestamp to a duration format?

I would like to convert a column containing timestamp data in the numeric "ddMonyyyy h:m:s" time format to a numeric time duration format in seconds, starting the duration in the first row of my datatable.
WHG

Discussions |
Nov 8, 2019 5:10 AM

2231 views | 1 replies
Finding the allowable limits for a factor to ensure low defect rates

Hi, Anyone has any idea how do we find the allowable limits that a few factors can operate in order to maintain a certain defect rates. This video from robert actually shows how to find the best settings in order to achieve lowest defect rate with the assumption of normal distribution in these factors. What I am looking for is how do i determine what is the maximum variation allowable in order to...
albiruni81

Discussions |
Nov 6, 2019 11:58 AM

4151 views | 7 replies
How to optimize formula columns for faster recalculation speed?

I have a fairly large JMP data table (132k rows, 2860 columns) which also has a large number of formula columns (200+). I regularly import new data into this file, so I want to keep all of the formula columns "live" so they will auto-populate when new data is added. I've started to run into issues with the speed of formula recalculation. At first the formulas were mostly simple arithmetic (addit...
Chris_Rodrigues

Discussions |
Nov 6, 2019 8:45 AM

2923 views | 2 replies
How Can I konw if the aliasing exists in the Alias Matrix?

How Can I konw if the aliasing exists in the Alias Matrixthe involving two-way interactions and main effects? For example, in this Alias Matrix, what does 1 and 0 mean?
Daa1029

Discussions |
Nov 6, 2019 6:48 AM

2711 views | 3 replies
Create a column based on values on other columns

I am trying to write a script whose values depend on the value of another column.I need to create a new column i.e second column below.Need to assign vales as followsSun = 1,Mon = 2 and so on.(4) => 2 , (6) => 4,5 => 1, 7 => 3Eg : Sun(5) is 11.How can I script this?Sat (4)72Sun (5)11Sun (4)12Mon (5)21Mon (4)22Tue (5)31Tue (4)32Wed (5)41Fri (7)63Wed (6)44Thu (7)53Thu (6)54Fri (6)64Sat (7)73
ENTHU

Discussions |
Nov 5, 2019 7:08 PM

2193 views | 3 replies

Previous
Next

Latest Discussions

How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

1930 views | 0 replies
Analysis of covariance (ANCOVA) for Split plot Design

Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
Harun-Or-Rashid

Discussions |
Oct 29, 2019 9:03 PM

1299 views | 0 replies
Send Expects Scriptable Object in access or evaluation of 'Send' Error

I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong? ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...
OneNorthJMP

Discussions |
Oct 10, 2019 8:43 PM

1338 views | 0 replies
Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
jemairsmartes

Discussions |
Sep 11, 2019 10:27 AM

2136 views | 0 replies
How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1375 views | 0 replies