cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

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

  • Can I use Local Data Filter on a Fit Group containing Graph Builder windows (w/o the Graph Builder getting obliterated)?

    I'm having an issue combining Graph Builder and Local Data Filter within Fit Group. As soon as the Local Data Filter is applied to the Fit Group, all of the Graph Builder objects immediately disappear. (Note, other platforms like Bivariate and Oneway are not affected by this and those windows remain after applying the Local Data Filter, only the Graph Builder windows disappear.) Here is a sample s...

    markschwab markschwab
    Discussions |
    Oct 25, 2022 1:29 PM
    1251 views | 1 replies
  • Cumulative sum by grouping and rolling values formula??

    I have a data set with groups, days and visits on those days.  I would like to get a rolling sum of every 3 days, so at day 3 the value would be sum of day 1, 2, 3, but on day 4 the value is the sum of days 2, 3,4.   And do this by group.  I know I can use the cumulative sum by group, but that returns the sum each day, so day 4, would be the sum of all 4 days, but I would like the first day to dro...

    chadyoder chadyoder
    Discussions |
    Oct 25, 2022 12:15 PM
    1390 views | 2 replies
  • Best practice for preventing namespace pollution/cross-talk when calling Functions in an included file

    There are several threads on this topic already, as well as a section in the Scripting Guide, but none really answer my question. I have two files, Main.jsl and Function.jsl, and I include the latter file in the former. There is a Function defined in Function.jsl that I wish to call inside of a For loop in Main.jsl. The problem I had is that the called Function also uses a For loop, and both the F...

    AutoSalamander3 AutoSalamander3
    Discussions |
    Oct 25, 2022 8:25 AM
    1457 views | 2 replies
  • How do I split text in a cell into rows without a delimiter?

    I would like to split data in my rows from looking like this:Start Letter No.End Letter No.Letter SequenceDelta D3033ABCD0.065to looking like this:Start Letter No.End Letter No.Letter SequenceDelta D3030A03131B0.0653232C0.0653333D0.065 Where the sequence of letters in the text are split into a single letter in each row and this is associated with it's corresponding number in the sequence. The 'Del...

    MarginOfMap112 MarginOfMap112
    Discussions |
    Oct 25, 2022 8:12 AM
    2078 views | 1 replies
  • Column Group with variable Column Count

    Query_DT << GROUP COLUMNS("WEEKS",COLUMN(12),75); COLGRP = Query_DT << GET COLUMN GROUP ("WEEKS"); Query_Stack = Query_DT << STACK(columns(COLGRP), Source Label Column( "Label" ), Stacked Data Column( "Data" ) );I need to group columns to create a stacked table..  the problem is that the number of columns can vary.  This code works fine, except in the Group Columns function I need the 75 to be ...

    Phil_Nash Phil_Nash
    Discussions |
    Oct 25, 2022 6:28 AM
    1298 views | 2 replies

Latest Discussions

  • Can I use Local Data Filter on a Fit Group containing Graph Builder windows (w/o the Graph Builder getting obliterated)?

    I'm having an issue combining Graph Builder and Local Data Filter within Fit Group. As soon as the Local Data Filter is applied to the Fit Group, all of the Graph Builder objects immediately disappear. (Note, other platforms like Bivariate and Oneway are not affected by this and those windows remain after applying the Local Data Filter, only the Graph Builder windows disappear.) Here is a sample s...

    markschwab markschwab
    Discussions |
    Oct 25, 2022 1:29 PM
    1251 views | 1 replies
  • Cumulative sum by grouping and rolling values formula??

    I have a data set with groups, days and visits on those days.  I would like to get a rolling sum of every 3 days, so at day 3 the value would be sum of day 1, 2, 3, but on day 4 the value is the sum of days 2, 3,4.   And do this by group.  I know I can use the cumulative sum by group, but that returns the sum each day, so day 4, would be the sum of all 4 days, but I would like the first day to dro...

    chadyoder chadyoder
    Discussions |
    Oct 25, 2022 12:15 PM
    1390 views | 2 replies
  • How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

    Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...

    SquaresDingo505 SquaresDingo505
    Discussions |
    Oct 24, 2022 7:23 PM
    724 views | 0 replies
  • How to create categorization from data with with known categories for comparison and categorization of a new data run of unknown category

    Scenario: I have 8 compounds A-H, for each compound I have 5 runs* of time-temperature data with a known category. I need to be able to compare a single data run of an unknown category to those existing runs and assign a category to that run. A few things going on which may also need accounted for:1) My start times (when heating began vs the data run started) do not all align.2) Not all runs end a...

    atoomey atoomey
    Discussions |
    Oct 24, 2022 8:13 AM
    6571 views | 10 replies
  • Change column names at once

    Hello, I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous co...

    bordini bordini
    Discussions |
    Oct 23, 2022 8:54 AM
    2932 views | 3 replies

Latest Discussions

  • How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

    Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...

    SquaresDingo505 SquaresDingo505
    Discussions |
    Oct 24, 2022 7:23 PM
    724 views | 0 replies
  • How to Analyze and Graph Responses with Supercategories

    I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories.  I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification?  PS:  I don't know how to do JSL scripting.

    TCM TCM
    Discussions |
    Oct 21, 2022 5:59 AM
    768 views | 0 replies
  • 標準化列名稱如何用變數取代求解

    //新增周標準化
    weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
    weekEMC_HF_C_12 = {};
    //少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
    For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
    Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
    );
    Try(
    Local( {old dt = Current Data Table()},
    Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
    For Each( ...

    Ken697 Ken697
    Discussions |
    Oct 20, 2022 9:22 PM
    683 views | 0 replies
  • Methods for compressing a CSV or TSV file with jmp compression to save as .jmp table without having to open the csv in JSL first?

    I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this: MyDataFile = open(filename,Private); MyDataFile << Compress File When Saved; MyDataFile << save(filetosa...

    CurbStegosaurus CurbStegosaurus
    Discussions |
    Oct 14, 2022 9:06 AM
    1834 views | 0 replies
  • Model classification thresholds add-in display "negative" probability

    Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...

    Agustin Agustin
    Discussions |
    Sep 13, 2022 6:43 AM
    580 views | 0 replies
view all discussions