Using this JMP platform, you specify only the primary table and one or more secondary tables, and Query Builder automatically matches foreign keys in the primary table to primary keys in the secondary tables. This can make for significant work and require you to learn not only the details of the data tables but also how to use SQL or other tools to join them.Įnter Query Builder. You have to join those tables to assemble the data you need. This means that the data you need for analysis is scattered across multiple tables. Whatever the format, JMP is ready.ĭatabases allow organizations to catalog massive amounts of data and information, but databases are usually organized for efficient storage and transactions, not for efficient analysis. csv and more and pull data directly from ODBC-compliant databases using the interactive Query Builder, from data on the web or in the cloud through APIs. Fortunately for you, JMP is hungry for data and has the data connectors you need to be productive, fast.Įasily read from Microsoft Excel using the Excel Import Wizard out of files such as.
0 Comments
Leave a Reply. |