Welcome to the JMP User Community!

Latest Discussions

• 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

  5837 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

  15673 views | 11 replies

• Select large number of rows

  Hello,
  I am looking for tips to help me select a large number of lines easily. Indeed, I work with large databases and when I want to select 15000 lines for example, I click on the first line and I scroll down to 15000. Then when I want to select the following 15000 lines I click on line 15001 and I scroll down to 30001 with my computer mouse
  I tried with keyboard keys but it's also very long ...
  Do ...

  Emma1

  Discussions |

  Feb 26, 2021 5:09 AM

  2403 views | 2 replies