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 9/19/2017