Welcome to the JMP User Community!

Latest Discussions

• Problems with Execute SQL: JMP crashes, need help troubleshooting

  I'm rewriting an old App to include more features. Part of the App is pulling some data from a database. I'm copying that code exactly as it was in the old App.When I'm tyring to execute that code in the new app, JMP crashes violently. It was giving me some error windows, now it just stops running. It does produce crash reports, though, in "...AppData\Local\Temp\JMPCrashReports\13". So, if I isola...

  miguello

  Discussions |

  May 11, 2018 1:34 PM

  3577 views | 2 replies

• JSL Question: How to 'flatten" a list of lists

  I would like to convert a "list of lists" e.g.mylist={{"a","b"}, {"c", "d"}, {"e","f", "g"}}into a simple list with each element from the nested lists e.g.// desired outcome is this list flat_list={"a","b","c","d","e","f","g"}Is there a simple way to do this in JSL?  In general, the nested lists may also contain lists, and the depth of nesting may not be the same for each element in the starting l...

  MathStatChem

  Discussions |

  May 10, 2018 6:29 PM

  6573 views | 4 replies

• UNION QUERY - HOW TO DO IT?

  Dear All, We are looking for your help. We are creating a query that extract the data from several tables (as usual), but we would like to do a Union between two primary tables. An example of how our SQL query looks like is below. How can we achieve this using the Query Builder? So far, we can query the db using only the first part of the query before the UNION statement. We have read the JSL book...

  anaheilman

  Discussions |

  May 10, 2018 2:16 PM

  4706 views | 5 replies

• Column quantiles or probabilites by ...

  I need jsl code that will save the probabilities of a given column distribution, by other columns. I know how to do this un-scripted by taking a distribution of the column by the other columns and then under the red action button while holding control, and selecting Save Prob Scores.  But I don't know how to script this.I looked through other posts but didn't find an answer to how to script the ab...

  pcarroll1

  Discussions |

  May 10, 2018 12:44 PM

  7909 views | 4 replies

• List of tables: how to interactively update and not loose the selection

  I have seen discussion on this topic, and I couldn't find the solution.The problem is the following: I'm orking with the list of tables that is displayed in a List Box. I use N Table() way of getting a list of names for all the tables.What I want is that if I click to select any lines in that list - the list itself updated and checked if there are new opened tables or some tables were closed.Good ...

  miguello

  Discussions |

  May 10, 2018 12:00 PM

  5130 views | 4 replies