Welcome to the JMP User Community!

Latest Discussions

• Make Combined Data Table from Journal in jsl

  Hi community! I have the attached Journal, and I want to make a combined data table from the Summary Statistics and Capability Analysis. I checked the tree structure, but I'm unsure on how to make the correct reference. I was trying with the below but it didn't work. Any clues? Current Journal()["Summary Statistics"][Tablebox(2)] << Make Combined Data Table; 

  oscarmforero

  Discussions |

  Jun 5, 2020 1:58 AM

  3106 views | 2 replies

• Column Formula for summary value of group based on values in 2 other columns

  Hi everyone - I'm looking for a column formula that would return the following desired column below.  For simplicity in this post each group has 3 rows, but the dataset I currently have has groups with varying numbers of rows. Any help appreciated!  GroupTimeScoreFirst Time Failed (Desired Column)A1Pass8A3Pass8A8Fail8B1PassPassB2PassPassB6PassPassC1Pass3C3Fail3C7Fail3 

  user8421

  Discussions |

  Jun 4, 2020 5:08 PM

  3903 views | 2 replies

• How do use JSL to quickly compare two sets of range columns in order to get the minimum of each column?

  The title is a bit hard to understand. Take this big class as an example:
  1. First, summarize the average values of "height" and "weight" by age.
  2. Then summarize the median of "height" and "weight" by age.
  3. Then compare the mean and median of "height" and take their minimum.
  Finally, compare the mean and median of "body weight" and take their minimum. I'll use the following code and finally loop t...

  lwx228

  Discussions |

  Jun 4, 2020 3:49 PM

  3095 views | 4 replies

• HTML import as data table issue

  I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!".  when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...

  danielharding0

  Discussions |

  Jun 4, 2020 2:01 PM

  2957 views | 4 replies

• Unstacking a Stacked Excel Cell or Parsing Free-form Text to Generate Multiple Rows

  We all run into some version of this: Excel table formatted to look nice, no thought given to analyzability.In the free-form text cell, it looks like this: m/d: text [alt+enter]
  m/d: text [alt+enter]
  m/d: text [alt+enter]
  m/d: text [alt+enter]
  ...
  m/d: text [alt+enter] When the data are exported to JMP, the cell gets collapsed into: m/d: text m/d: text m/d: text ... m/d: text.
  I want to parse that long ...

  markschahl

  Discussions |

  Jun 4, 2020 11:47 AM

  3303 views | 3 replies