JMP User Community

Latest Discussions

add tab to journal that has tabs already

I have a report with tabs that I created a journal from.Let in script, I need to add to the journal sometimes - I want more tabs in it. Example code is below, but it always puts the new tabs on the bottom of one of the other tabs. The behavior I want is 5 tabs in the journal'd output.Any help to do this? I tried add instead of append, but can't seem to find right command.Thanks,Joe nw = new windo...
jetpeach

Discussions |
Nov 11, 2019 9:18 AM

3067 views | 2 replies
Greek letters/special symbols in column names and axis titles

Dear all, I work with a lot of physical units, which often have greek letters, subscripts, or superscripts in their definitions. I would like to be able to include these units in the column names so that reports, graph builder, etc, automatically display the correct units, with correct symbols and formating. Is this possible to do? I cannot seem to figure it out from the forum or my own experime...
pjkiley

Discussions |
Nov 11, 2019 8:46 AM

7577 views | 6 replies
select where on multiple columns

I have a data table with 60 columns and I'm trying to select columns which have "Test" in their name.I then need to select all 1.values that lie in the range 50 & -50 in Test_AB;2.values that lie in the range 100 & -100 in Test_CD;3.values that lie in the range 200 & -200 in Test_EF; and delete other rows.Is there an easy way to do this in JSL? Thanks
ENTHU

Discussions |
Nov 10, 2019 10:26 PM

4599 views | 3 replies
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

7387 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

5053 views | 2 replies

Previous
Next

Latest Discussions

select where on multiple columns

I have a data table with 60 columns and I'm trying to select columns which have "Test" in their name.I then need to select all 1.values that lie in the range 50 & -50 in Test_AB;2.values that lie in the range 100 & -100 in Test_CD;3.values that lie in the range 200 & -200 in Test_EF; and delete other rows.Is there an easy way to do this in JSL? Thanks
ENTHU

Discussions |
Nov 10, 2019 10:26 PM

4599 views | 3 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

2233 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

4157 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

2928 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

2712 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

1931 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

1376 views | 0 replies