cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Scripting and very large files

    I have a script that imports many files and concatenates them.          This file can be >41 million rows and be in the 10's of Gigabits (I have 100's of GB free space and 128GB memory : Using JMP16.2) I then have scripts to select rows and columns and such.  My question really is not about scripting per se, but why if I run each script in order versus having a script that includes all the scripts...

    justvince justvince
    Discussions |
    Feb 18, 2022 9:02 AM
    2698 views | 5 replies
  • Randomly choose an element in a list and remove the chosen one for next round

    Hi all,I have a list[1,2,3,4,5,6,7,8,9,10] that I want to randomly choose an element, and then remove that element from the list for the next random selection. I need to repeat the selections 4 times.Is there a easy way to remove the selected element in the list? Both Remove and Remove From need the ith index of the elements. Thank you for your help. 

    midori555 midori555
    Discussions |
    Feb 17, 2022 10:15 PM
    2893 views | 3 replies
  • Nested loops with List boxes

    I am trying to construct a 2D-matrix with 2 nested FOR-loops used in the mouse over hover labels (Graph builder -> Hover Label Editor -> Graphlet).I provide here a simplified example for 2*2 matrix.  hlb = H List Box(); vlb = V List Box(); For (row=1, row<=2, row++, For (col=1, col<=2, col++, hlb << append(Text Box("Row: "|| char(row) ||", Col: "|| char(col) )) ); vlb << append(hlb); ); v...

    JanneI JanneI
    Discussions |
    Feb 17, 2022 1:00 PM
    1900 views | 4 replies
  • Combining Date Column and Time Column to Create Timestamp

    For a data table with a date column and a time column, I create a new column that uses the formula Date + Time to create a timestamp.  However the formula seems to work inconsistently where some of the timestamps result in being 4 YEARS previous than what they should be.

    DateTimeTimestamp (formula)2021 - 10 - 0112:05 AM10/01/2021 12:05 AM2021 - 10 - 236:59 PM10/23/2017 6:59 PM2021 - 11 - 077:45 PM1...

    user8421 user8421
    Discussions |
    Feb 17, 2022 12:16 PM
    2748 views | 3 replies
  • Remove the "Where" from Window and Change grouping column names

    I am looking to remove the "Where..." from my window, but it does not work as I thought it should. I tried the same method that does work for graphs (as noted by @txnelson).I am guessing it's just a simple naming convention issue? I am also trying to rename my table's grouping column :Identity to "Phase". nw =New Window("window title", V List Box( tb = concat<<Tabulate( Change Item Label(G...

    Raybob Raybob
    Discussions |
    Feb 17, 2022 9:54 AM
    1347 views | 2 replies

Latest Discussions

  • Scripting and very large files

    I have a script that imports many files and concatenates them.          This file can be >41 million rows and be in the 10's of Gigabits (I have 100's of GB free space and 128GB memory : Using JMP16.2) I then have scripts to select rows and columns and such.  My question really is not about scripting per se, but why if I run each script in order versus having a script that includes all the scripts...

    justvince justvince
    Discussions |
    Feb 18, 2022 9:02 AM
    2698 views | 5 replies
  • Random vs Fixed Blocking Factor in DOE

    Hello All,

    I am trying to setup a custom DOE experiment where I am evaluation 4 continuous factors with 1 response. I have a limit of 30 runs and am interested in main effects (later I would like to do two-way interactions as well if possible). I set this run up but because these 30 runs have to be split over two imaging platforms I use a blocking of two with 15 runs per. I tried with a fixed block...

    Ekarshalev Ekarshalev
    Discussions |
    Feb 17, 2022 8:36 AM
    4584 views | 3 replies
  • JSL, delete a column if there's only 1 'group', labeled in another column?

    Curious about this. I've got a dt with several thousand columns that I'm scripting some cleansing for further analysis. The data set is process data, where each row is a unique process run from a given machine. Some machines don't report out all the full list of sensors, so I'm stuck with a few hundred columns only coming from a single machine. I'd like to purge these, as I can't do any statistica...

    aliegner1 aliegner1
    Discussions |
    Feb 16, 2022 4:48 PM
    1208 views | 3 replies
  • Heatmap with Entire Row and Column Selections

    I have a 2x3 heatmap that I am able to plot using Graph Builder - no problems.  What I would like to do is have an additional set of cells for the user to select entire rows or entire columns of cells.  It would look something like this:Question: How can I add the additional C1, C2, R1, R2, and R3 cells to the heat map to allow for the selection of the entire row or column of cells (data table row...

    Martin Martin
    Discussions |
    Feb 16, 2022 2:24 PM
    3043 views | 7 replies
  • Adjusting spacing between figure categories

    Is there a way to adjust the spacing between categories within figures. I frequently make bar graphs and dot plots with multiple categories and am unable to distinguish different groups. In this example I am plotting mass against SAID (Sample IDs) and number of cycles. I would like to separate the SAIDs to help visualize the samples separately. Is there a way to do this without changing the width ...

    MW_JMP MW_JMP
    Discussions |
    Feb 16, 2022 11:21 AM
    1797 views | 2 replies

Latest Discussions

  • No table linking after saving the project?

    Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...

    hogi hogi
    Discussions |
    Feb 3, 2022 4:19 AM
    597 views | 0 replies
  • Setting Guardbands on Test Limits Using EMP

    Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...

    Jbritsch04 Jbritsch04
    Discussions |
    Feb 2, 2022 8:49 AM
    769 views | 0 replies
  • How to introduce lower bounds for simulated data in Profiler platform

    Hi JMP community,   (JMP Pro 16.0.0)   I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...

    SDF1 SDF1
    Discussions |
    Feb 1, 2022 11:09 AM
    589 views | 0 replies
  • Query Builder filtering on date stored in Varchar(20)

    Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO]      ,[DESPA...

    HansD HansD
    Discussions |
    Jan 25, 2022 6:12 AM
    1390 views | 0 replies
  • M1 Macbook Pro JMP Capabilities

    Hi all, 
    I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...

    MikeDereviankin MikeDereviankin
    Discussions |
    Jan 21, 2022 1:52 PM
    789 views | 0 replies
view all discussions