cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace

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

  • Converting A Range of Alphanumeric Characters Into A List (X1-3 to X1,X2,X3)

    Hello,I'm trying to convert a range of alphanumeric characters into a list. I'm pretty new to JSL and I'm not sure exactly how to go about doing this. This is what I would like to achieve: Orginal: CH1-3Return: CH1,CH2,CH3 The character prefix does not always contain two characters (Could be CH1-3 or X5-8 for example). I know that if I had a range of just two numbers, like CH1-2,  I could use the ...

    Stepper Stepper
    Discussions |
    Jun 5, 2018 8:57 AM
    8348 views | 5 replies
  • Creating a Variable

    I have an issue while creating an overall measure of time. I have attached a screenshot that shows what the data looks like thus far. I need to now create a variable that is called "time in trial" where I basically take the "Nback start" minus the "Nback stop." More specifically I would need several things to happen. 1. When "Nback # of letters presented" equals 1 the "time in trial" should equal ...

    tlsimons tlsimons
    Discussions |
    Jun 5, 2018 7:59 AM
    2099 views | 1 replies
  • Convert a list of strings into a column names

    I am trying a to run a script that uses a regex to find column names and puts them in a list to then stack. I am struggling to get the actual stack part to work and I think it has to do with the list containing strings rather then column names. Is there a way to convert a list strings into column names? ref = open(dir||datafile); allColNames = ref << getcolumnnames; edgeCols = {}; Ncols = N item...

    tarkan_bih tarkan_bih
    Discussions |
    Jun 5, 2018 12:49 AM
    4885 views | 1 replies
  • Retrieving a path and filename after Save Presentation() is used with no path specified

    I am using Save Presentation() to save a journal to ppt.  However, I want to allow the user to specify the path and file name to save the ppt.  If the Save Presentation() is specified without specifying a path/filename, JMP very nicely pops up an operating system Save File window, which allows the user to navigate to whatever folder they desire, and to specify whatever filename they desire.  The i...

    txnelson txnelson
    Discussions |
    Jun 4, 2018 12:28 PM
    6374 views | 6 replies
  • SQLQuery

    Hi, I've made a sqlquery.jmp from an excel file (xlsm).When I execute for the first time: no pb. the jmp file is created.but when I try to update the jmp file by "update from Database" (I use JMP14), the file is not updated.The excel file is write protected. In excel, the file requests a password for writing / reading. I can only open it as read-only.is it the explanation?What should I check ? tha...

    Françoise Françoise
    Discussions |
    Jun 4, 2018 10:18 AM
    6032 views | 2 replies

Latest Discussions

  • Creating a Variable

    I have an issue while creating an overall measure of time. I have attached a screenshot that shows what the data looks like thus far. I need to now create a variable that is called "time in trial" where I basically take the "Nback start" minus the "Nback stop." More specifically I would need several things to happen. 1. When "Nback # of letters presented" equals 1 the "time in trial" should equal ...

    tlsimons tlsimons
    Discussions |
    Jun 5, 2018 7:59 AM
    2099 views | 1 replies
  • Conditional formatting in a data table

    Hello, I'm trying to apply conditional formula for columns in order to apply cell color but I can't achieve successful result. Any suggestions how to do it? I believe I am using wrong formula here. Example: ColumnsUV            UV to reject0.15              0.15 Formula: If( :UV == :UV to reject,
     Color Of( "Red" ),
     "White"
    ) Idea is that JMP highlights the cell in color red if the value is equal to...

    robertasme robertasme
    Discussions |
    Jun 3, 2018 2:38 PM
    4845 views | 5 replies
  • How do I get the import file settings right before transposing and joining two files by script?

    I have two sources of data that I need to put together and create a master tabel for analysis and reporting.One is in .csv (Resulst 1) and another is in .xlsx (Results 2) format. The file in .xlsx format I need to specify individual worksheet settings and which sheet to open when importing. I have seen the following posts but have not managed to get it to work:https://community.jmp.com/t5/JMP-Scri...

    ivomdb ivomdb
    Discussions |
    Jun 1, 2018 8:52 AM
    6612 views | 1 replies
  • relative standard deviation on graph builder

    Dear all, I  have 10 individual results. And I want to use graph builder to show RSD% or Coefficient of variance on graph. As ı remember I can directly select CV on summary statistic part of graph builder from the previous version of jmp. However I use JMP 14 and I do not see this property now. Is there anyone can help me? am ı remember wrong? Best Regards, 

    nac nac
    Discussions |
    May 31, 2018 8:54 AM
    4179 views | 1 replies
  • Is it possible to apply the same data filter to two separate graphs from two different data tables

    I am writing a script for a report that automatically imports, rearranges and then produces all the relevant graphs and statistical analyses in the one screen as a final report. I wish for bar chart and area plot (produced from dt and dt3 respectively - see below) in the report to have the same data filter applied to them, which changes both the plots simultaneously. However, I can only get the on...

    nhun nhun
    Discussions |
    May 31, 2018 6:03 AM
    2258 views | 3 replies

Latest Discussions

  • Why does Profiler not stop

    All, 
         I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this.      I am using JMP 13.   

    uday_guntupalli uday_guntupalli
    Discussions |
    Apr 27, 2018 7:12 AM
    1555 views | 0 replies
  • P value, L-R Chi Square, Prob Chi Square in Choice results

    Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...

    aryasohrabi aryasohrabi
    Discussions |
    Mar 17, 2018 2:22 AM
    3543 views | 0 replies
  • Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

    Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...

    Picard Picard
    Discussions |
    Mar 15, 2018 1:57 PM
    2379 views | 0 replies
  • pseudo r square in JMP choice model platform

    Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...

    DG DG
    Discussions |
    Mar 11, 2018 6:27 AM
    2004 views | 0 replies
  • chnging colors on PCA plot

    Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga

    helga55 helga55
    Discussions |
    Mar 9, 2018 2:20 PM
    3246 views | 0 replies
view all discussions