cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Practice JMP using these webinar videos and resources. We hold live Mastering JMP Zoom webinars with Q&A most Fridays at 2 pm US Eastern Time.See the list and register. Local-language live Zoom webinars occur in the UK, Western Europe and Asia. See your country jmp.com/mastering site.

Choose Language Hide Translation Bar
Accessing Databases

 

See how to:

  • Import files and single tables
  • Connect to a database, including how to locate drivers and connect to a user of machine data source (DSN)
  • Assure that the bitness (32- or 64-bit) of the ODBC driver matches that of the version of JMP being used

 

See how to: 

  • Use interactive Query Builder to select tables, automatically join tables and turn off table auto join
  • Use selection boxes to define a query, aggregate data, sample data and filter data based on user-supplied value
  • Build a saved query where the user is prompted to filter or order results each time the query is run
  • Modify or update data when rerunning a query

Some questions answered by JMP Developer Eric Hill @Eric_Hill :

 

Question: When in the initial Query Builder window where you can join tables, can you join between secondary tables?

Answer: Absolutely.  Any table in the query can be joined to any other. 

 

Question: Can I join two tables if key/column is numeric in one table and character in the other?

Answer: For some databases, join columns with mismatched types are coerced to be the same type, but others not.  If you have this situation, the  best thing to do is drop into custom SQL and cast the string to a number.  Though this StackOverflow article suggests that SQL will just do the conversions on your behalf.

 

Question: When one chooses to aggregate using Average, how is that done? For example, in the Movie Rental example, when we take average age, is that averaging across unique customers or looking at all the records within the movie information that defines a group? The concern is that if a customer is renting multiple times the same movie, they might get counted multiple times and thus the sample size would be inflated. I suspect this might be dependent on the DB type.

Answer: The database is going to average across whatever rows are in each group.  The best thing to do is to make the query you want without aggregating, making sure if you only want each customer to be present one time that that’s what you’ve got, and then apply the aggregation.  It may require custom SQL or doing one query that gets the rows you want and then a JMP query against the result that does the aggregation.

 

Resources:

Recommended Articles