JMP 14.0 Online Documentation (English)
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Predictive and Specialized Modeling
Multivariate Methods
Quality and Process Methods
Reliability and Survival Methods
Consumer Research
Scripting Guide
JSL Syntax Reference
JMP iPad Help
JMP Interactive HTML
Capabilities Index
JMP 13 Online Documentation
JMP 12 Online Documentation
Using JMP •
Import Your Data
•
Build SQL Queries in Query Builder
• Open the Selected Data in JMP
Previous
•
Next
Open the Selected Data in JMP
After you specify the columns and data to import, click
Run Query
to open the data in a data table. The SQL statements are saved as a table variable. The following scripts are available:
Source
Runs the query.
Modify Query
Opens the query in Query Builder, where you can change which columns and data are imported and further customize the query.
Update From Database
Connects to the database to refresh the data and then run the query. If the data table and database table contain the same number of columns, values in the existing data table are updated when the database is refreshed.
The existing data table is also updated when only formula columns follow the last column that is refreshed.
Otherwise, the updated data appears in a new data table.
Previous
•
Next
Help created on 7/12/2018