cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

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

  • Editing the Distribution Title by matching WaferID w/ By Statement

    Hello, I would like to edit the title of my distribution graphs to be a bit more descriptive and easier to match up with another graph I created. I would like the title of each graph to be "Wafer = XYZ..., BatchID = ABC..."  The code I created below lets me edit the title, however, it unsurprisingly lists all the batchids that were listed in the associative array I made prior. (this array just lis...

    saneal saneal
    Discussions |
    Jul 5, 2021 2:06 PM
    4680 views | 10 replies
  • Supprimer l'heure de l'affichage Calendar Box

    Bonjour, J'ai un code JSL qui demande à l'utilisateur de spécifier un intervalle de temps via une Calendar Box. Mon code fonctionne bien je souhaite seulement pouvoir supprimer l'affichage de l'heure qui ne m'est pas utile par la suite. Est ce que c'est possible ?         dt1=Today(), dt2=Today(), HListBox( PanelBox( "From Time", scal = Calendar Box(SetFunction(Function({this}, date1=scal<< Get ...

    Elise_B Elise_B
    Discussions |
    Jul 5, 2021 7:08 AM
    1523 views | 3 replies
  • Concatenate selected row from multiple subsetted data tables into 1 new data table

    Hi,

    I have a data set(as example, Big Class) that contains all the data. I subset the data by age and select first row of each
    subsetted data table. Then, I subset it again so that I can do concatenation of the selected row data into new table.

    I notice that there is additional data (unwanted data ) concatenated in the new table (highlighted in red rectangular).
    I am not sure what is the problem o
    ...

    bzanos bzanos
    Discussions |
    Jul 5, 2021 5:06 AM
    1728 views | 2 replies
  • Fixed line style based on name in Graph Builder

    Dear, I would like to know if and how it is possible to always have a fixed line style/color based on a certain criteria (e.g. in the case below based on the Quarter).If you take the sample data file "Australian Tourism" and plot the Room occupancy (%) versus Year you would get something like below,where I changed the line style for Quarter 2 to be dashed.However when I select only Quarters 2,3 an...

    PietVanmeerbeek PietVanmeerbeek
    Discussions |
    Jul 5, 2021 2:40 AM
    1707 views | 3 replies
  • Error on Filter Condition on SQL Query

    Hi,I am trying to get data from a Access DB via SQL Query.I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such value is stored in the study_id_selected variable.It seems that the syntax of the SQL Query filter is not correct because I get the following error:Below you can find the whole script. Could you tell me whic...

    FabioSaragoni FabioSaragoni
    Discussions |
    Jul 5, 2021 1:37 AM
    1365 views | 1 replies

Latest Discussions

  • Fixed line style based on name in Graph Builder

    Dear, I would like to know if and how it is possible to always have a fixed line style/color based on a certain criteria (e.g. in the case below based on the Quarter).If you take the sample data file "Australian Tourism" and plot the Room occupancy (%) versus Year you would get something like below,where I changed the line style for Quarter 2 to be dashed.However when I select only Quarters 2,3 an...

    PietVanmeerbeek PietVanmeerbeek
    Discussions |
    Jul 5, 2021 2:40 AM
    1707 views | 3 replies
  • Error on Filter Condition on SQL Query

    Hi,I am trying to get data from a Access DB via SQL Query.I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such value is stored in the study_id_selected variable.It seems that the syntax of the SQL Query filter is not correct because I get the following error:Below you can find the whole script. Could you tell me whic...

    FabioSaragoni FabioSaragoni
    Discussions |
    Jul 5, 2021 1:37 AM
    1365 views | 1 replies
  • How to seperate columns into different tables.

    I have a datatable with 5 columns. Field names are from from A to Z. Now i want to seperate this table into 5 si gnetables. Every table just contain one column. The table A has one column A. Until the table E ha e one column Z. Can you give me suggestion on JSL?

    GoodMan GoodMan
    Discussions |
    Jul 4, 2021 6:38 AM
    2964 views | 8 replies
  • How to export a formula to excel?

    Hello, I have a master prediction formula that consists of 4 different prediction formulas. To develop prediction formulas I used Boosted trees and Boosted forest. So once I combined them together to get the master prediction formula I ended up having a complex and complicated formula. As the next step, I want to export the master prediction formula to excel. I was wondering is there any way that ...

    Dm1229 Dm1229
    Discussions |
    Jul 3, 2021 6:18 PM
    1303 views | 1 replies
  • Take value from specific cell to create a column

    Hello, In JSL, I want to use a specific cell value to create a column. how can I do it?From this:ID 1122 NameAgeJohan23David34Jack27to This: IDNameAge1122Johan231122David341122Jack27

    ileshem ileshem
    Discussions |
    Jul 3, 2021 4:13 AM
    2043 views | 2 replies

Latest Discussions

  • Section 508 compliance

    Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)?  I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful?  Maybe this is a wish list item?

    GGfGA GGfGA
    Discussions |
    Jun 30, 2021 10:03 AM
    853 views | 0 replies
  • Multi File Import of network folder slower in latest JMP version

    Hello, In JMP 14, Multi File Import of a network folder was relatively fast. For example, it takes ~11 seconds to load the below folder. With JMP 16 on the same computer/folder/network, it will first spend almost 3 minutes while "discovering files", before proceeding with the above "loading file names" step. Are there any settings or options that I could change to skip the "discovering files" step...

    jach jach
    Discussions |
    Jun 22, 2021 11:06 AM
    707 views | 0 replies
  • ODBC Hive connection, change container size in the script?

    Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings". I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call. How would I do this through JMP? I already have the Cloud...

    aliegner1 aliegner1
    Discussions |
    Jun 17, 2021 3:43 PM
    949 views | 0 replies
  • Using a List to Filter in Custom Query Builder - Question

    Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...

    Benjamin_S Benjamin_S
    Discussions |
    Jun 3, 2021 7:59 AM
    1256 views | 0 replies
  • Can I control text size in a word cloud inside a dashboard container?

    Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...

    caseylott caseylott
    Discussions |
    Apr 28, 2021 12:03 PM
    1241 views | 0 replies
view all discussions