Welcome to the JMP User Community!

Latest Discussions

• How to look up data and create new column based on nearest match?

  I have sample data in table sample1 and the look up table efficiency( please find attached both the tables). I want to find the closest match of data column in table sample1 with resplect to IOUT column in look up table efficiency. Based on the nearest match I want to populate efficiency column in table sample1 in accordance with look up table:Below is the code I am trying
  /* Open a sample data tab...

  jojmp

  Discussions |

  Jun 27, 2019 6:05 AM

  2637 views | 2 replies

• Appending element to a list value inside an associative array

  Hi, I am trying to add an element into an associative array where the value is a list and the element needs to be added into the list inside associative array.Eg:cary = ["high schools" => {"Cary", "Green Hope", "Panther Creek"}, "population" => 116244, "state" => "NC", "weather" => "sunny"]; In this,1. How can I add a new entry to "high schools" list?2. How do I convert the "weather" value to list...

  dileepkr

  Discussions |

  Jun 27, 2019 2:27 AM

  7627 views | 2 replies

• Not a JMP question, but hoping someone can help - Estimating StdDev from Min, Max, Avg

  Firstly, this is not a JMP question but a gereral statistics question, so I apologize if it's inappropriate to post it here.  But I'm hoping someone in the JMP community can help with it. I have a series of data samples, where each sample has Min, Avg (Mean), and Max recorded.  The data is sampled every second, but only recorded every 15 minutes.  So each of my 15-minute data points has the Min of...

  wsande

  Discussions |

  Jun 26, 2019 2:02 PM

  8438 views | 7 replies

• best practices around special characters in JSL?

  example="blah blah Width = 25.0 �m ..some more stuff"; widthtext=regex(example,"Width\s=\s+\d+[.]\d+\s[\w?�]m");

widthtext=regex(example,"Width\s=\s+\d+[.]\d+\s[\w?\x{FFFD}]m"); Sorry this is less a very specific problem that a general issue I'm looking for recommendations on as I've had this issue in different contexts.    In this specific example I'm using loadtextfile() to get some text that I ...

  hardner

  Discussions |

  Jun 26, 2019 11:45 AM

  11375 views | 4 replies

• JSL - How to iterate over Bivariate and save all splines to 1 column

  Hello.  I have created an array of strings, containing the various values found in one of my columns. I would like to generate a spline for every value that is in my array of strings, and save all predicted points to a new column.  I am able to iterate over Bivariate(), changing a where-clause with each iteration to a new value in my array of strings, however, only the last predicted points are sa...

  adjo9835

  Discussions |

  Jun 26, 2019 5:03 AM

  4483 views | 4 replies