User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Formatting numbers in a loop

    Hello,

    I'm formatting decimal numbers in a loop, and it works on the first row but the 2nd row and thereafter it throws a type error

    for each row(my_data, :my_col = Format( :my_col, "Fixed Dec", 16, 3, "Use thousands separator"); );Error: <Column "my_col" changed to type Character to match formula.>

    First row everything formats fine but I can't seem to figure out why it fails after.

    Thanks 

    aharro aharro
    Discussions |
    Jul 17, 2024 3:04 PM
    1304 views | 3 replies

  • JMP 18 python pptx import not seeming to work

    Hi all,  My company has just got the JMP 18 license and the PowerPoint automation is not working anymore due to the dependencies. From JMP documentation I have understood that python is now an integrated version in which case dependencies have to be installed through jmputils. Below is the code I have so far for the imports the powerpoint used to use. I am still getting the same error even with th...

    neelsrejan neelsrejan
    Discussions |
    Jul 17, 2024 12:44 PM
    3480 views | 5 replies

  • Stack output table name

    Hi,I have a script that dynamically parses some of the info for stack table and would like to store the stack table as a new data table. ystr1 = ":INFRASTRUCTURE Value, :INFRASTRUCTURE Value 1"infr = "Infrastructure Value";data = "PPT";output_name = "infra_updated.jmp";gbStr = EvalInsert("dt << Stack(columns(^ystr1^),Source Label Column(^infr^ ),Stacked Data Column(^data^),Output Table(^output_nam...

    skollcruz23 skollcruz23
    Discussions |
    Jul 17, 2024 7:02 AM
    1979 views | 6 replies

  • How to get process parameter yield by wafer in a lot?

     I want to get process parameter yield per "Wafer ID in lot ID" from the sample data table "Semiconductor Capability.jmp". However, I am not able to proceed as I am getting an error: "Process Screening requires at least 7 rows of data." Names Default To Here (1); clear log (); dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp"); col_names = dt << Get Column Group("Processes"); ps = dt << Proc...

    Neo Neo
    Discussions |
    Jul 17, 2024 4:20 AM
    1973 views | 4 replies

  • How to reference a list of n columns when joining data tables?

    I am fairly new to JSL and have very basic knowledge on coding in general, so I may not know all of the proper terms to describe my problem, so I apologize in advance. I want to automate a process I do regularly where I combine and transform 2 data tables. I already have a script that can do this, but I am trying to figure out how to have JMP reference columns instead of having them hard-coded bec...

    GraysonC GraysonC
    Discussions |
    Jul 16, 2024 3:52 PM
    1337 views | 3 replies

Latest Discussions

  • Formatting numbers in a loop

    Hello,

    I'm formatting decimal numbers in a loop, and it works on the first row but the 2nd row and thereafter it throws a type error

    for each row(my_data, :my_col = Format( :my_col, "Fixed Dec", 16, 3, "Use thousands separator"); );Error: <Column "my_col" changed to type Character to match formula.>

    First row everything formats fine but I can't seem to figure out why it fails after.

    Thanks 

    aharro aharro
    Discussions |
    Jul 17, 2024 3:04 PM
    1304 views | 3 replies

  • How to apply a formula to all columns in another table?

    I am trying to take a table and apply a moving average to every function to every column. The script below is what I am trying, based on what I saw in another thread here. The goal is to make a new table and then apply the function while referencing the original. However, I keep getting a scoped data table access error.   Test = Open("C:\Users\abrokaw\Desktop\JMP MA Test Table.jmp"); //open value...

    GroupEdgeColt67 GroupEdgeColt67
    Discussions |
    Jul 15, 2024 9:02 AM
    1408 views | 3 replies

  • Turn off "Suppress Eval" on all columns

    Is there a way to turn off "Suppress Eval" for all columns? (It seems to have automatically turned on "Suppress Eval" when I saved a .jrp, and I need to evaluate many formula columns in this data table.)

    MarkJSchwab MarkJSchwab
    Discussions |
    Jul 15, 2024 6:39 AM
    1986 views | 4 replies

  • SQL Query Case Sensitivity Issue

    I'm using JSL to retrieve data from a MySQL database. However, I've encountered an issue where the filtering conditions in my SQL query are case-insensitive by default. This means that the results returned are the same regardless of the case of the filter value.

    Here are the two scripts that produce the same results:
    Script 1:
    New SQL Query(
    Version( 130 ),
    Connection(
    "ODBC:DATABASE=my_database;DSN=my_...

    Arthur Arthur
    Discussions |
    Jul 15, 2024 2:17 AM
    2401 views | 5 replies

  • How does one perform Bitwise operations in JMP formulas?

    Hi, I imagine this is simply an issue in which I am not finding the correct formula option but how does one perform basic bitwise operations in a JMP formula? e.g. Here's an example Python example that I would like to replicate in JMP: lambda x: ((((x>>1)&0x1))<<2) thanks, Ross

    docrossus docrossus
    Discussions |
    Jul 11, 2024 3:18 PM
    4561 views | 6 replies

Latest Discussions

  • Tracking down a cycle error

    When I open a data table, I get a cycle detected error that I have to ignore every time. I can't seem to figure out what is causing the error although it apparently has something to do with the table variable in my column formula.  Here is the formula: and here is the log entry showing the issue  Can anyone help me understand what is going on here? The data table actually works fine after I click ...

    scott1588 scott1588
    Discussions |
    Jun 24, 2024 11:47 AM
    1099 views | 0 replies

  • How do I make scattorplot Matrix with multiple cloumns I select?

    Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...

    NagneTE1 NagneTE1
    Discussions |
    May 27, 2024 5:18 PM
    787 views | 0 replies

  • graph builder bug - x group shift

     (JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups  are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...

    ShlomiB76 ShlomiB76
    Discussions |
    Apr 14, 2024 12:08 AM
    720 views | 0 replies

  • Project ignoring H Splitter Box Set Sizes . . . sometimes

    I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...

    ionatx ionatx
    Discussions |
    Apr 4, 2024 1:25 PM
    710 views | 0 replies

  • Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

    Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...

    sm3001 sm3001
    Discussions |
    Mar 21, 2024 12:49 AM
    932 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference