cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
cgoggin
Level I

Query Builder missing "Random N rows" sample option

Hi, 

 

  I've noticed with JMP 18.1.2 and MySQL ODBC 8.1 Unicode driver that I'm not seeing the option to sample the result set by a random number of rows.  Is this an option that was dropped from JMP or the driver?  Is there a way to get it back in query builder?

 

Thanks

1 REPLY 1

Re: Query Builder missing "Random N rows" sample option

JMP doesn't seem support this with My SQL since it's not builtin natively in the database.

It would be a new feature.

Feel free to add it to the wish list.

 

In the meantime, you can mimic it with custom SQL with something likeL

SELECT * FROM your_table
ORDER BY RAND()
LIMIT n;

That might work.

Recommended Articles