Welcome to the JMP User Community!

Latest Discussions

• Date imported from Excel in 1904

  Hello Community!  I am trying to do a script to automatically import an Excel file and create some graphs. I have a file with a column of date (dd Mon yyyy) which is important as it will be my X axis (Excel file attached).If I go directly from the Excel file to JMP using the add-on button, it’s working perfectly well, I get my datatable with my Date column properly formatted. But I want to script ...

  Elofar1

  Discussions |

  Nov 2, 2023 7:00 AM

  1508 views | 1 replies

• How to select individual cell based on condition and insert it?

  Hello
  I am trying to select an individual cell based on condition and insert it to a column in JSL.
  For example:I have this following table - I want to insert to the first row under column "value"  the "score" value of the second row (11) because:
  when looking on the first and second row:home = home and y=y and x=x+1Input:scorehomeyxvalue10US11 11US12 10Canada11 10US35  Expected: scorehomeyxvalue10U...

  septon

  Discussions |

  Nov 2, 2023 2:59 AM

  1043 views | 1 replies

• What is not possible via JSL?

  https://community.jmp.com/t5/Discussions/Is-it-possible-to-show-excluded-row-values-on-chart-via-JSL/m-p/690346/highlight/true#M87620  Where are the limits? I mean:- where is the the GUI/mouse user ahead of his JSL colleague?
  - where is a hard wall for any Jmp user?

  hogi

  Discussions |

  Nov 1, 2023 3:05 AM

  4850 views | 11 replies

• save matrix as table variable?

  Hi.  I'm wondering if it is possible to save a matrix or list to a table as a variable, as in:Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); dt << New Table Variable("Day_mat", [42 43]);This did not work of course, but is there another way?  One option I'm considering is saving it as a table script instead, as in:Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp")...

  nikles

  Discussions |

  Oct 31, 2023 9:25 AM

  3008 views | 5 replies

• extract the folder name from file directory

  How can I extract the folder name from file directory? I will use the folder's name as the name of the data table when saving it. I am using JMP 15.I tried this piece of code I saw here but still cannot extract the folder name. I Dir = ""; p = pick Directory("Select a Folder", Dir); f = Files In Directory(p); Dir = Substr( p, 1, Length( p ) - Length( Word( -1, p, "\/" ) ) - 1 );Ex. File path: C:...

  UserID16644

  Discussions |

  Oct 31, 2023 4:59 AM

  1721 views | 2 replies