cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

  • Script to open Data Filter on currently-selected column, with Find and Regex enabled

    Full disclosure: I'm not a coder and JSL gives me a particularly difficult time, however I feel that this portion of the script I am writing should be far easier than it has been. I use the Data Filter frequently, with "Find" and "Regular Expressions" enabled (see image), however there is no option to save these settings so they must be cumbersomely re-enabled every time I open the filter. What I ...

    ionatx ionatx
    Discussions |
    Oct 18, 2019 7:12 PM
    7746 views | 6 replies
  • New SQL Query -- Join when one dt has variable # of columns

    I have a script that joins four tables using the JMP Query Builder. A condensed example of the script is below. This works with a fixed number of columns, however dt1 can have any number of columns and I need to incorporate all of them. The remaining three tables have specific columns for inclusion, all other columns need to be dropped. Names Default to Here( 1 ); dt1 = Open( "C:\...\dt1.jmp", in...

    ionatx ionatx
    Discussions |
    Oct 18, 2019 1:09 PM
    3862 views | 2 replies
  • How do can save a JMP file with the column name as a CSV file?

    I searched the Discussions posts, and saved JMP as TXT file first, and then changed TXT name to CSV.But my JMP default does not check "Export Table Headers".
    How can the JSL be saved as a CSV file with the column name?I added "Export Table Headers(1)" in the code, which did not work.Thanks!

    lwx228 lwx228
    Discussions |
    Oct 18, 2019 2:33 AM
    2813 views | 2 replies
  • Iterating Through Rows Question

    Hello, I'm so grateful for all of the previous replies, and am learning more and more about JSL every day. At this point, I am comfortable with the basics, and have learned about For loops, For Each Row and use of the Formula function. This was very helpful. As I mentioned in my previous post, I'm working on a dataset, and have 4 key columns: 1) PATIENTID: list of unique values for patient number
    2...

    SrihariGopal SrihariGopal
    Discussions |
    Oct 17, 2019 4:36 PM
    4576 views | 4 replies
  • How do I plot row number in Graph Builder?

    As a former gnuplot user, I could plot column "0" as one of the axis, and it would plot the row number on that axis.   Obviously I could do this with a formula column ("row()"), but is there a way to do this without having to create a new column in my table?

    BHarris BHarris
    Discussions |
    Oct 17, 2019 1:21 PM
    4130 views | 3 replies

Latest Discussions

  • How do can save a JMP file with the column name as a CSV file?

    I searched the Discussions posts, and saved JMP as TXT file first, and then changed TXT name to CSV.But my JMP default does not check "Export Table Headers".
    How can the JSL be saved as a CSV file with the column name?I added "Export Table Headers(1)" in the code, which did not work.Thanks!

    lwx228 lwx228
    Discussions |
    Oct 18, 2019 2:33 AM
    2813 views | 2 replies
  • How to get from JMP table format WIDE to LONG. With some twists... [JSL, scripting]

    Hi, Simply put, I just need to get from JMP format WIDE to LONG.I'll use BIG CLASS to outline the basic idea: dt = Open( "$SAMPLE_DATA/big class.jmp" );Basic objective: Structure BEFORENAME AGE SEX HEIGHT WEIGHT KATIE 12 F 59 95 LOUISE 12 F 61 123 JANE 12 F 55 74 JACLYN 12 F 66 145Structure AFTER (let's see NAME and SEX as IDs)NAME SEX SOURCE_COL VALUE KATIE F AGE 12 LOUISE F AGE 12 JANE F AGE 1...

    Newbie2Jumpie Newbie2Jumpie
    Discussions |
    Oct 17, 2019 8:02 AM
    2368 views | 1 replies
  • Nelson rules

    When n=1, how to use nelson rule

    TPL4 TPL4
    Discussions |
    Oct 16, 2019 5:50 PM
    2894 views | 3 replies
  • How to make Candlestick Charts with JMP?

    Hi Experts!
    I found the drawing JSL in several sample JMP files for stocks, but did not find a way to make the Candlestick Charts.dt = Open( "I:\00\jmp\Samples\Data\TechStock.jmp" );

    lwx228 lwx228
    Discussions |
    Oct 15, 2019 5:05 PM
    3521 views | 5 replies
  • Control Chart Builder Subgroups with Different Specs

    I have JMP 10 and would like to know if there is a way to use Control Chart Builder and add different specs for each subgroup chart (there are 3 subgroups: Material = A, B or C). The current script adds the same spec limits to all subgroup charts. Control Chart Builder(
         Show Control Panel( 0 ),
         Variables(
              "Subgroup"(:Material),
              "Subgroup"(:Name( "DataLabel" ), Position( 1...

    Raquel Raquel
    Discussions |
    Oct 15, 2019 8:22 AM
    1342 views | 1 replies

Latest Discussions

  • 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 OneNorthJMP
    Discussions |
    Oct 10, 2019 8:43 PM
    1353 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 jemairsmartes
    Discussions |
    Sep 11, 2019 10:27 AM
    2155 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 GhostBen
    Discussions |
    Aug 5, 2019 8:00 PM
    1398 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
    1358 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
    1452 views | 0 replies
view all discussions