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

  • Multiple excel file import, extracting data from specific sheet

    Dear expert JMP users, I have a lot of data files generated by an instrument that I've used - each one is consistent in format but they are all in individual sub-folders and each folder contains other files that are not of interest.Is there a way of writing a script (I'm completely new to JMP scripting) to look in all sub-folders of a given directory, search for excel files ending in ' infos.xlsx'...

    JMPinthePool JMPinthePool
    Discussions |
    Sep 15, 2023 7:46 AM
    3141 views | 4 replies
  • How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

    Big Class.jmpThanks!Function( {thisTable, thisColumn, iRow}, {}, n1rows = thisTable << Get Rows Where( :n1 == thisTable:thisColumn[iRow] ); n2rows = thisTable << Get Rows Where( :n2 == thisTable:thisColumn[iRow] ); thisTable << Select Columns( {thisColumn, :n1, :n2} ) << Clear Cell Colors; thisColumn << Color Cells( {3, {iRow}} ); :n1 << Color Cells( {3, n1rows} ); :n2 << Color Cells( {3, n...

    lala lala
    Discussions |
    Sep 15, 2023 7:33 AM
    1282 views | 2 replies
  • What is the JSL equivalent of Cols>> Column Names>>Move Up ?

    For an open data table, what is the JSL equivalent to Cols>> Column Names>>Move Up ?(cannot see the script in the log when I do this interactively)I need to make the first row of my data table as header (via JSL). I am on JMP 16. 

    Neo Neo
    Discussions |
    Sep 15, 2023 1:50 AM
    2225 views | 5 replies
  • format date

    Bonjour,Je dispose d’une BD avec deux colonnes : entrée et sortie.
    Ces colonnes sont des dates mais sont au mauvais format.
    Par exemple la cellule 14,45 correspond à 14h45. J’ai essayé en modifiant le format de la colonne en disant qu’en entrée il s’agissait de format numérique et en sortie je voudrais « h:m » comme ci dessous :  cela ne fonctionne pas, avez-vous une idée pour résoudre ce problème ...

    hcarr01 hcarr01
    Discussions |
    Sep 14, 2023 11:38 PM
    1688 views | 3 replies
  • Inherited Plot settings

    Hi,
    I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

    One example:
    If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...

    hogi hogi
    Discussions |
    Sep 14, 2023 11:11 PM
    648 views | 0 replies

Latest Discussions

  • Multiple excel file import, extracting data from specific sheet

    Dear expert JMP users, I have a lot of data files generated by an instrument that I've used - each one is consistent in format but they are all in individual sub-folders and each folder contains other files that are not of interest.Is there a way of writing a script (I'm completely new to JMP scripting) to look in all sub-folders of a given directory, search for excel files ending in ' infos.xlsx'...

    JMPinthePool JMPinthePool
    Discussions |
    Sep 15, 2023 7:46 AM
    3141 views | 4 replies
  • Inherited Plot settings

    Hi,
    I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

    One example:
    If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...

    hogi hogi
    Discussions |
    Sep 14, 2023 11:11 PM
    648 views | 0 replies
  • conditional data filter + invert selection: bug?

    When a data filter is configured to be conditional, selections in one filter affect the values which are displayed in other filters:   When the user opens the red triangle menu and clicks on clear selection, the filter is reset and the other filters are adjusted accordingly. Surprising: When the user opens the red triangle menu and clicks on invert selection, the selection is just inverted, but no...

    hogi hogi
    Discussions |
    Sep 14, 2023 11:39 AM
    2963 views | 8 replies
  • How to show the actual range in the level values in Graph Builder?

    Hi,   In the attached plot, the property of column "ChannelNumber" is Numeric/Continuous. I found it confusing in the grouped values at the top. "0-4" actually includes 0-3, as shown at the bottom; "4-8" actualy includes 4-7. It seems the range at the top always has overlapping values between adjacent levels. What can I do to make this overlap go away (i.e. I want it to show "0-3", "4-7","8-11" at...

    JaneYang JaneYang
    Discussions |
    Sep 14, 2023 11:28 AM
    5440 views | 13 replies
  • Simpler way to save a new script to data table

    (1) I compose a script in a new script window by 'save to script window' for a number of actions, e.g. filtering, plotting etc. This window is not connected to the data table, yet.(2) To save the script I  go to the data table, open a new script, give it a name, copy paste content from the other script window and then save. Is there a simple way to save the script to the data table without first h...

    Ake Ake
    Discussions |
    Sep 14, 2023 6:15 AM
    1049 views | 1 replies

Latest Discussions

  • Inherited Plot settings

    Hi,
    I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

    One example:
    If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...

    hogi hogi
    Discussions |
    Sep 14, 2023 11:11 PM
    648 views | 0 replies
  • Mixed model: which specifications for cross-over designs?

    I ran a cross-over trial where healthy volunteers came to the lab twice (separated by a wash-out period) and underwent sensory testing at both arm and foot, before and after one of two neuromodulation interventions. Each participant underwent both conditions in a randomly assigned order. We want to see if the neuromodulation interventions affected the outcomes differently for the arm and the foot....

    arnaudsteyaert arnaudsteyaert
    Discussions |
    Sep 13, 2023 7:30 AM
    841 views | 0 replies
  • Exporting Graphs from Tab box to Excel cell

    Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel  Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...

    Jackie_ Jackie_
    Discussions |
    Sep 12, 2023 2:09 PM
    718 views | 0 replies
  • Discrete Choice Experiment: Prohibited Combination

    Hi everyone,I would like to design my first DCE. I am going to use 6 attributes that differ in the levels from 2 to 4 levels. However, I have a limitation where there is an impossible combination that may appear; for example, the cheapest product would not be possible to have the best feature. Is there any way for me to select the prohibited combination? Or, is the D-optimal design will always cal...

    andikawp andikawp
    Discussions |
    Sep 6, 2023 7:11 AM
    704 views | 0 replies
  • Multivariate Analysis

    Using Multivariate Analysis to study the pattern of any specific issue (e.g. water consumption of different states in a country). From T2 plot for abnormal observations we get contribution plot that shows which states are highest contributor. The Contribution plot here shows only the name of contributors. If it possible to indicate in numeric value [How much water each state is consuming]?

    Chitranshu Chitranshu
    Discussions |
    Sep 4, 2023 3:01 AM
    638 views | 0 replies
view all discussions