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
• Query Builder Red Triangle Options
Previous
•
Next
Query Builder Red Triangle Options
The Query Builder red triangle menu provides scripting and custom SQL options. The modify and run scripts are always automatically saved in the final data table.
Copy Modify Script
Copies a script to the computer’s clipboard that lets you modify the query.
Copy Run Script
Copies a script to the computer’s clipboard that lets you refresh the data and run the query.
Save Modify Script to Script Window
Saves the Modify Query script to the script window.
Save Run Script to Script Window
Saves the Update From Database script to the script window.
Convert to Custom SQL
Shows the query statements in a new script editor window. You must remove prompting filters before selecting this option.
When you save the query from the Custom SQL window, the custom SQL is saved. Interactive components that were present before you customized the query are not saved. Revert to Interactive is also unavailable on the red triangle menu.
Keep this query compatible with JMP 12
Makes subsequent changes to the query compatible with JMP 12. Features that cause compatibility issues with JMP 12 are hidden while you edit the query. After you deselect this option and make a change that is supported only in JMP 13 and later, this option is no longer available.
The JMP Query Builder preferences include the same option, which is deselected by default. When you open a query in JMP 13 that is marked as JMP 12 compatible, features that create compatibility problems are hidden regardless of how the preference is set.
Revert to Interactive
Displays the interactive query in the Query Builder window. Changes that you made on the Custom SQL tab are not saved when you revert.
Previous
•
Next
Help created on 7/12/2018