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

  • 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
  • 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
    1353 views | 3 replies
  • Adding outlines horizontally in journal

    I'm looking to make a journal with "Smaller outlines" within "Bigger outlines". I don't want the top outline to expand vertically, but rather horizontally.  Edit: I see from an example journal (that looks like what I want) that the "Smaller Outlines" boxes should be List boxes with button boxes underneath... but I don't see an option to add either of these?   

    aidanweb aidanweb
    Discussions |
    Jul 27, 2023 11:40 AM
    1723 views | 3 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
    1353 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
    1244 views | 2 replies

Latest Discussions

view all discussions