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

  • replacing numbers with strings

    hey,i have a column COL_A, which has 31 rows for wach number between 1 - 31 ( 31 rows of 1, 31 rows of 2 .... etc), and i want to replace those numbers with 31 strings in a specifiec order, for example:if my string are in this order: horse, cat, dog ....etc, i want to replace the 1's with horse, the 2's with cat, the 3's with dog...., what is the best and fastest way to do it?

    adham_saif adham_saif
    Discussions |
    Aug 21, 2019 3:55 AM
    3424 views | 3 replies
  • Merging time series with timestamp and duration

    I would like to merge the following tables 1 (time series with certain events, ~2000 datapoints) and 2 (time series with duration and amplitude data, ~1,000,000 datapoints) into a table like 3: 1:timestampevent20:23:56:962A event20:24:14:964B event...... 2:time [s]amplitude0-0.0004577640.00006250.0642700195...... 3:timestamptime [s]eventamplitude20:23:56:9620A event-0.00045776420:23:56:9620.000062...

    WHG WHG
    Discussions |
    Aug 21, 2019 3:19 AM
    3359 views | 5 replies
  • how to use join, update and concatenate

    Hi need more information when to use this tools:  join, update and concatenate.Witch one shoul i use to combine to two table that have same column names  but different ID patients? How to add all the patients and make one table? Another question is how to update a table with new data?

    Batista Batista
    Discussions |
    Aug 20, 2019 6:02 PM
    6859 views | 3 replies
  • How to pass a date to an SQL Query in JMP

    I’m getting a data sheet via SQL into JMP. One column is a :Date column. I’d like to pick the last date (Max value) or "last date-1 day" from this :Date column and transfer this date into an update querry, where CustomSQL( “ … Date >= ...) is.

    Thomas1 Thomas1
    Discussions |
    Aug 20, 2019 8:22 AM
    2802 views | 1 replies
  • How do I prevent JMP Alerts from popping up?

    When I use a combo button on the dashboard I get a JMP Alert. Nevermind what the alert says because it runs smoothly besides the popup. Is there a way to prevent or close that Alert within the script?   I have tried:     Combo11 << Batch Interactive ( 1 ); throw(); stop();     Thanks for the help!

    Kelly Kelly
    Discussions |
    Aug 20, 2019 7:30 AM
    2153 views | 1 replies

Latest Discussions

  • replacing numbers with strings

    hey,i have a column COL_A, which has 31 rows for wach number between 1 - 31 ( 31 rows of 1, 31 rows of 2 .... etc), and i want to replace those numbers with 31 strings in a specifiec order, for example:if my string are in this order: horse, cat, dog ....etc, i want to replace the 1's with horse, the 2's with cat, the 3's with dog...., what is the best and fastest way to do it?

    adham_saif adham_saif
    Discussions |
    Aug 21, 2019 3:55 AM
    3424 views | 3 replies
  • Merging time series with timestamp and duration

    I would like to merge the following tables 1 (time series with certain events, ~2000 datapoints) and 2 (time series with duration and amplitude data, ~1,000,000 datapoints) into a table like 3: 1:timestampevent20:23:56:962A event20:24:14:964B event...... 2:time [s]amplitude0-0.0004577640.00006250.0642700195...... 3:timestamptime [s]eventamplitude20:23:56:9620A event-0.00045776420:23:56:9620.000062...

    WHG WHG
    Discussions |
    Aug 21, 2019 3:19 AM
    3359 views | 5 replies
  • copy column from one table to another (bring the formula and the heading

    Hi. I have two tables. one with the heading and formula I need.And at other tables is the one with the formulas. How can copy the column from one table (bring the formula and the heading) to another. Thanks

    Batista Batista
    Discussions |
    Aug 19, 2019 9:19 AM
    2649 views | 3 replies
  • Interactively changing menu in an add-in

    I have developed a handful of add-ins that are similar but slightly different.  Each contains 30-40 scripts. Most of the scripts are the same,but some of the scripts available are different.  The differences are based on geography.  I would like to combine these into one add-in with the ability to select geography.  For example, if the user selected "Europe" as geography, the menu would change to ...

    johnmoore johnmoore
    Discussions |
    Aug 16, 2019 12:16 PM
    1423 views | 1 replies

Latest Discussions

  • 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 GhostBen
    Discussions |
    Aug 5, 2019 8:00 PM
    1374 views | 0 replies
  • Capability Animation - How to see the LSL/USL Value?

    I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?

    Antonio80 Antonio80
    Discussions |
    Jul 9, 2019 1:31 AM
    1314 views | 0 replies
  • Unable to allocate enough memory in access or evaluation

    Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a  73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...

    ns ns
    Discussions |
    Jul 8, 2019 9:04 AM
    1436 views | 0 replies
  • How to Post JSON data to a site via API functionality: "Unsupported Media Type"

    Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...

    liqinglei419 liqinglei419
    Discussions |
    Jul 2, 2019 6:33 AM
    1667 views | 0 replies
  • How to analyze crossover design data in JMP

    I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?

    sharmachetan sharmachetan
    Discussions |
    Jun 14, 2019 2:34 PM
    1285 views | 0 replies
view all discussions