Welcome to the JMP User Community!

Latest Discussions

• How to Save Queried Data Table to a Specified Folder through script?

  Hi! Does anyone here knows how to save a queried data table to a specified folder through jmp script? Can't seem to find the right way in doing it... Thanks in advance!Here's my sample script:Data Table( "name of data table" ); //save raw data table to a folder dt = current data table (); filepath = "C:\Users\folder path"; dt<< save(filepath || "name of data table.jmp");

  ramisola

  Discussions |

  May 1, 2021 5:30 AM

  1669 views | 2 replies

• extracting month

  Hello, I have a column containing a timestamp in the following format:Jan-01Feb-01 How can I use formula to parse the month so that it would return:JanFeb I tried month(:Name("My-Column")) but it is giving me a red squiggly line.  Thank you so much for your help!

  aprilmayjune

  Discussions |

  Apr 30, 2021 1:10 PM

  1395 views | 3 replies

• How to Identify Unique Values in a Column from a Data Table (to a Scripting Newbie)

  Assuming I am familiar with programming languages in general, but not the syntax of JMP/JSL specifically, please understand that when I looked up JSL: get unique values of a data table column and Get a list of the unique values in a column, matrix, or list none of the solutions worked for me when I try to find a summary of the unique values in a column scriptorially (not via Recode). The reason fo...

  mostarr

  Discussions |

  Apr 30, 2021 10:58 AM

  3096 views | 4 replies

• How to use JSL to classify and summarize the data in the middle of the matrix branch, and get the summary results in the form of matrix?

  For "Big Class.jmp", the "height" and "weight" columns are written into the matrix.
  Then the data in rows 6 to 35 of the matrix are classified and summarized: the average weight of each height is summarized.This result only needs to be stored in the in-memory matrix. Thanks Experts!I wonder if this is possible?dt=Open("$SAMPLE_DATA/Big Class.jmp"); ar=dt<<GetAsMatrix({4,5}); Summarize(ar[6::35,0],e...

  lwx228

  Discussions |

  Apr 30, 2021 10:21 AM

  1922 views | 4 replies

• Can I subset only text from the Methods section of a batch of reports when each report's full text is already in a JMP column?

  Hi everyone, I have a JMP table that includes the full text of a bunch of journal articles. Each each record has the article's title in one column (as an ID) and the articles full text in another. I am interested in creating a new column that only has the text from the Methods section of each paper. I started to think that this might be possible after watching the @brady_brady "Recode Review" tuto...

  caseylott

  Discussions |

  Apr 30, 2021 9:41 AM

  1700 views | 3 replies