Welcome to the JMP User Community!

Latest Discussions

• How to script the difference between time stamp

  Hello all, I am working on a script that checks the missing data for users. We record data every 5 minutes. If the difference between 2 timestamps is larger than 5 minutes we define that there is missing data for that period of time. And the format of the time in my data table looks like this:2018-07-09 00:58:07.70300002018-07-09 00:58:07.70300002018-07-09 00:58:07.7030000Does anyone know how shou...

  Anonymous

  Discussions |

  Jul 11, 2018 6:51 AM

  6615 views | 4 replies

• JMP Alert: File not Found

  Hi, I'm creating the following script for a journal:OKScript = Expr( win1 << CloseWindow; lf = ListF << GetItems; If( N Items( lf ) < 1, Warning( "ERROR: You need to select at least one file" ); Throw(); ); For( i = 1, i <= N Items( lf ), i++, print(lf[i]); dt=Open(lf[i]); ); ); ); lf holds the list of file names that the user selected from a directory. I keep getting a 'JMP Aler...

  Jaz

  Discussions |

  Jul 11, 2018 6:19 AM

  10005 views | 5 replies

• Exclude certain rows in data analysis

  I recently imported a survey that I created on Qualtrics.  The survey was 30 minutes long so some people stopped halfway through or at the beginning etc..  I gave each question a point value to make the survey like a test and assign grades.  But when I look at final points, this includes users who chose to terminate the survey early and do not have responses from that point forward.  How do I excl...

  nhi225

  Discussions |

  Jul 11, 2018 6:03 AM

  8026 views | 2 replies

• How to insert multiple data without column name?

  Below is JSL to make JMP table. dt = New Table( "Floor Example",
       New Column( "Unit ID", Character, Nominal ),
       New Column( "Data1", Numeric, Continuous, Format( "Best", 12 ) ),
       New Column( "Data2", Numeric, Continuous, Format( "Best", 12 ) ),
       New Column( "Data3", Numeric, Continuous, Format( "Best", 12 ) ),
  );dtdata={
    {Unit ID = "A", Data1 = 1.1, Data2 = 2.1, Data3 = 3.1},
    {Unit ID...

  Kwangki

  Discussions |

  Jul 11, 2018 5:25 AM

  5776 views | 2 replies

• How to automatically update rows with file name from a dynamic data import?

  I'm working on a script that imports multiple files from a folder into a single data table. I have created a column listed USP_ID, in which I would like the filename to appear in each row. Although the data imports correctly, only the name of the final imported excel file is displayed in this column, whereas I would like each file name to be displayed in the rows corresponding to its respective da...

  nhun

  Discussions |

  Jul 11, 2018 3:59 AM

  5815 views | 2 replies