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

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Latest Discussions

  • Tables/Update changed!

    Please note, there is a significant change of the Tables/Update functionality in JMP19. dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); // Update data table Data Table( "Big Class" ) << Update( With( Data Table( "Big Class Families" ) ), Match Columns( :name = :name, :age = :age ), Replace Columns in Main Table( None ) );   Available columns afte...

    hogi hogi
    Discussions |
    Sep 25, 2025 12:56 AM
    1738 views | 4 replies
  • Single Column V look up equivalent

    Hey everyone, So I have been using a formula that works in the same way as vlookup in excel but I have now discovered that it does not work on larger data tables as it basically bogs down and kills JMP.   Attached is a sample data table and where I have split out the two functions that I had combined which works as expected:       VLU Item   VLU Result         If I were to take the formula from...

    shampton82 shampton82
    Discussions |
    Sep 21, 2025 10:21 PM
    1482 views | 7 replies
  • Tips and Tricks - best practice with JMP/JSL

    There is a wonderful blog post by @Craige_Hales : How Do You Draw a Circle?  It nicely illustrates that there are multiple solutions to every problem - with varying degrees of success in achieving the goal and in investing ressources.   And often there is not the ONE solution with maximum points in all categories: goal was metlength of codespeed (to write the code)speed (to execute the code)comple...

    hogi hogi
    Discussions |
    Sep 21, 2025 10:04 PM
    5316 views | 7 replies
  • How to order my values including supercategories created?

    Hello, I have created supercategories but can't order my values including my supercategories in a specific order (ex: supercategory Top2Boxes, then supercategory TopBox, then each of my value in descending order 'strongly agree' etc.). How can I do this please? Many thanks and kind regards, 

    Nath Nath
    Discussions |
    Sep 19, 2025 2:13 AM
    487 views | 4 replies
  • Why is Tables/Concatenate so slow?

    Has this ever happened to you?
    Sometimes it takes a very long time for Tables/Concatenate to finish merging two tables.More than a minute for just a few columns and some 100k rows.What could be the reason? 

    hogi hogi
    Discussions |
    Sep 17, 2025 11:47 PM
    2052 views | 5 replies

Latest Discussions

  • Tables/Update changed!

    Please note, there is a significant change of the Tables/Update functionality in JMP19. dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); // Update data table Data Table( "Big Class" ) << Update( With( Data Table( "Big Class Families" ) ), Match Columns( :name = :name, :age = :age ), Replace Columns in Main Table( None ) );   Available columns afte...

    hogi hogi
    Discussions |
    Sep 25, 2025 12:56 AM
    1738 views | 4 replies
  • How to order my values including supercategories created?

    Hello, I have created supercategories but can't order my values including my supercategories in a specific order (ex: supercategory Top2Boxes, then supercategory TopBox, then each of my value in descending order 'strongly agree' etc.). How can I do this please? Many thanks and kind regards, 

    Nath Nath
    Discussions |
    Sep 19, 2025 2:13 AM
    487 views | 4 replies
  • Why is Tables/Concatenate so slow?

    Has this ever happened to you?
    Sometimes it takes a very long time for Tables/Concatenate to finish merging two tables.More than a minute for just a few columns and some 100k rows.What could be the reason? 

    hogi hogi
    Discussions |
    Sep 17, 2025 11:47 PM
    2052 views | 5 replies
  • how to Resolution Problem with Formula for Column

    Code:  If( !Contains(col_name_list, "EFT (h)"), Current Data Table() << New Column( "EFT (h)", Numeric, Continuous, Format("Fixed Dec", 10, 1), Formula( :Name( "duration" ) * 24 ) ) ); Error: Unexpected ")". Perhaps there is a missing ";" or ",". Line 9 Column 6:    ))►)   The remaining text that was ignored was ) Resolution Problem with Formula for Column EFT (h):   I am unable to ...

    zetaVagabond1 zetaVagabond1
    Discussions |
    Sep 16, 2025 1:59 AM
    1810 views | 7 replies
  • Copy Formula for Tables / Update

    In Tables / subset, the user can decide if a column formula is copied and if the evaluation is suppressed:   Is there a hidden option which does the same trick for Tables/Update?

    great for "documentation"great for "what if" ...on the other hand: one cannot guarantee that all input columns for the formula will be available in the target data table.
    -> default option "suppress formula evaluation"?

    hogi hogi
    Discussions |
    Sep 12, 2025 7:47 AM
    913 views | 0 replies

Latest Discussions

  • Copy Formula for Tables / Update

    In Tables / subset, the user can decide if a column formula is copied and if the evaluation is suppressed:   Is there a hidden option which does the same trick for Tables/Update?

    great for "documentation"great for "what if" ...on the other hand: one cannot guarantee that all input columns for the formula will be available in the target data table.
    -> default option "suppress formula evaluation"?

    hogi hogi
    Discussions |
    Sep 12, 2025 7:47 AM
    913 views | 0 replies
  • How to adjust the size of R plot imported with get R graphics(); ?

    I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want?   R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...

    CountableModel1 CountableModel1
    Discussions |
    Jan 15, 2025 4:01 PM
    621 views | 0 replies
  • user defined Transform Category?

    How can I create a custom function which shows up in the Character submenu of  the new formula column menu? 

     

    hogi hogi
    Discussions |
    Dec 4, 2024 5:01 AM
    444 views | 0 replies
  • Error add-in manager :AddinID == selectionID

    I am taking the above error once i click to build currently selected add-in button at the add-in manager.  Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...

    Georgios_Tsim Georgios_Tsim
    Discussions |
    Oct 29, 2024 6:41 AM
    688 views | 0 replies
  • Machine data source list remove in "Database Operations"

    I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean

    Sean_ShCn0 Sean_ShCn0
    Discussions |
    Aug 22, 2024 7:24 AM
    911 views | 0 replies
view all discussions