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

  • Dynamic JSL Tree Box Creation from Hierarchical Data

    Can someone suggest a method of creating a dynamic nested tree box using Hierarchical Data. I tried for a couple of hours tonight and it is confounding me  I have some dummy data below to depict the relationships which is three levels deep. Obviously I don't want to hard code this as I will not know up front how many level of 'nesting' I will need to make. In reality it will be 10 or more levels. ...

    thickey thickey
    Discussions |
    Jul 28, 2023 1:01 PM
    4506 views | 8 replies
  • Get text from reporting platform

    Hello, Something I've struggled greatly with is how to Get *something* from platforms. In this case, it's the linear fit equation just under "Linear Fit". The Properties and Show Tree Structure menu both show different text exit boxes, so I've tried to grab them both and used Get (which isn't recognized by the platform, or maybe just the object), and Get text. Both do not grab the text I require. ...

    StarfruitBob StarfruitBob
    Discussions |
    Jul 28, 2023 12:00 PM
    2260 views | 5 replies
  • Delete consecutive repeating values

    I have a data table where some of the columns have values that repeat because the program that generates the data holds the last value if a new one isn't given.  This means I can't use the "select duplicate rows" option because that deletes all duplicates not just ones that are repeating. I also don't want to delete the rows, just the values in the "cells". 4.13.43.4 - delete value3.4 - delete val...

    JMPtxUser36 JMPtxUser36
    Discussions |
    Jul 28, 2023 10:30 AM
    1234 views | 2 replies
  • Challenges constructing a proper loop

    Hi, Im new to coding and having challenges constructing a functioning scriptdt = current data table(); //declaring and initializing variables// lt_min = 1; lt_max = 50; RSquare_th = 0.9999; count = 0; //loop while (count < 0.99999, //calculate x for each y value dt << New Column ("x", Numeric, formula(:y/ (:y + :avg_num))); //plot bivariate biv = dt << Bivariate( Y( :x ), X( :average_temp), ...

    ParametricStudy ParametricStudy
    Discussions |
    Jul 28, 2023 7:53 AM
    943 views | 1 replies
  • Issue dealing with char to num

    Hi Everyone
    I am manipulating data, long strings of numbers stored as characters. I was able to break them down to the single numbers in their own column but something I cannot fix is happening.
    Some numbers remain the same others are changing. An example of change is -8.7 turning into -8.6999999999999992894572642, this is screwing up the calculation and the comparison down the line. Round did not w...

    Miof Miof
    Discussions |
    Jul 27, 2023 2:00 PM
    1978 views | 4 replies

Latest Discussions

  • Delete consecutive repeating values

    I have a data table where some of the columns have values that repeat because the program that generates the data holds the last value if a new one isn't given.  This means I can't use the "select duplicate rows" option because that deletes all duplicates not just ones that are repeating. I also don't want to delete the rows, just the values in the "cells". 4.13.43.4 - delete value3.4 - delete val...

    JMPtxUser36 JMPtxUser36
    Discussions |
    Jul 28, 2023 10:30 AM
    1234 views | 2 replies
  • Challenges constructing a proper loop

    Hi, Im new to coding and having challenges constructing a functioning scriptdt = current data table(); //declaring and initializing variables// lt_min = 1; lt_max = 50; RSquare_th = 0.9999; count = 0; //loop while (count < 0.99999, //calculate x for each y value dt << New Column ("x", Numeric, formula(:y/ (:y + :avg_num))); //plot bivariate biv = dt << Bivariate( Y( :x ), X( :average_temp), ...

    ParametricStudy ParametricStudy
    Discussions |
    Jul 28, 2023 7:53 AM
    943 views | 1 replies
  • Option to Treat Distribution() as Modal

    Hi, Is it possible to treat the "Distribution" function as modal? I am looking to create a distribution report with an arbitrary number of Continuous Distributions that I will later modify or change via JSL. I found that a dialog opens when I run the code below, but execution is not halted and the rest of my code is run before I have a chance to select my columns of interest. I have also looked in...

    Connor_K Connor_K
    Discussions |
    Jul 27, 2023 1:52 PM
    1354 views | 3 replies
  • with nolock option in QueryBuilder option?

    Is there an option to run Query Builder including a "with nolock" statement to not tie up a database during a long data pull? Copying the QueryBuilder generated SQL into a script window and adding "with nolock"  produced an error.

    bittnere bittnere
    Discussions |
    Jul 27, 2023 5:43 AM
    4852 views | 8 replies
  • Creating formula using dynamic variables in for loop

    Hi All
    I did that one time, and it was painfully but I lost the script and the memory of that. Below what I am trying to do:

    Tweak_List = dt_Temp << Get Column Names("String"); For(i = 1, i <= N Items(Tweak_List), i++, a = Left(Tweak_List[i], Length(Tweak_List[i]) - 1) || "Δ"; b = Tweak_List[i]; c = Left(Tweak_List[i], Length(Tweak_List[i]) - 2); dt << New Column(Left(Tweak_List[i], Lengt...

    Miof Miof
    Discussions |
    Jul 26, 2023 10:04 PM
    1245 views | 2 replies

Latest Discussions

view all discussions