Welcome to the JMP User Community!

Latest Discussions

• Two questions for "Big Class Families.JMP"

  1. Can the picture in the "picture" column be imported from the computer's hard drive or from the Internet?For example, how to use the JSL implementation to add "c:\1.png" to dt[1,1].  2. How the script "Graph Builder with Pictures"s:"UniqueID(1180683047)," and "Origin({70.1036850751071, 172.033784817876})," are determined.How can these numbers be computed using functional formulas?

  lwx228

  Discussions |

  Feb 26, 2021 5:49 PM

  3202 views | 5 replies

• Data leakage

  Hi I have read several post on data leakage between the test and training groups. The common suggestions to avoid leakages: 1 Split the database in training and test set before any normalization, standardization and missing value imputation  2 in case of time series avoid the random split. Decide a time cut point and use it to separate  the training and test set. Any comment, suggestions, useful r...

  FR60

  Discussions |

  Feb 26, 2021 1:38 PM

  5843 views | 11 replies

• Filemaker and SQL Query

  Hello,Since the introduction of the SQL Query builder, I tried many times to use this tool without success. So I use the old way (open database) which force me to build manually the SQL queries. Now that we can mix external databases and JMP tables, I'd like to give a second chance to Query builder. It still doesn't work. The error message :The connexions with the Database works fine (I made an up...

  claude_bellavan

  Discussions |

  Feb 26, 2021 11:19 AM

  19394 views | 10 replies

• Correct argument to limit open() to jmpaddin files

  The JMP syntax reference says that  open() can be limited to different file types. File Type An optional string that specifies the type of file that you are opening (for
  example, "text", "journal", "sas", "script", "png", and "jmp"). This can be useful if your file
  does not have a file extension, the file extension of the file does not match the contents of
  the file, or you want to import a JSL BLOB....

  johnmoore

  Discussions |

  Feb 26, 2021 9:14 AM

  1369 views | 1 replies

• Open microsoft office 365 cloud-based excel from JMP/JSL?

  JMP recently got a built-in ability to open Google sheets.  Before that in scripts I was calling an R package called Googlesheets to open them.  Now my company is moving to office 365 so we'll have cloud-based shared excel sheets and I'm not sure how I'll be able to read from those.  Is anyone opening these directly in JMP/JSL?

  hardner

  Discussions |

  Feb 26, 2021 9:13 AM

  15675 views | 11 replies