Hello. My name is Canh Khong.
I work at Samson Rope Technology in Ferndale, Washington State.
Today, I am talking about how to build a Query Builder using JMP software.
Let's start with a working table that has a few columns
such as date, operator i nitial, job number, actual measurements.
The working table is just for manual data collection.
To analyze, we may need to add more information from other tables.
How can I do that? The answer is using a Query Builder.
Query Builder can extract desired columns from other tables
and join these columns to the working table that I call the Master Table.
The Master Table has all of the information needed for analysis.
Here are a few steps to build a Query Builder
to join the working table to another table.
These steps are as simple as point, click, drag and drop.
Now, the Master Table is ready for data analysis.
However, if needed, a new column with a formula can be manually created
adding to the Master Table,
and JMP will automatically create the corresponding script of a new column.
Copy and paste the script to the Post Query Script.
If this is done, there is no need to spend time to recreate the new column.
The new column will be updated and shown every time the Query Builder runs.
If desired, the report can be manually created.
And JMP will create the corresponding script.
Copy and paste the script to the Post Query Script.
If this is done, there's no need to spend time to recreate the report.
The report will be automatically updated
and shown every time the Query Builder runs.
If desired, a chart can be manually created
and JMP will create the corresponding script.
Copy and paste the script to the Post Query Script.
If this is done, there is no need to spend time to recreate the chart.
The chart will be automatically updated
and shown every time the Query Builder runs.
One click to run the Query Builder.
This will produce the updated Master Table,
the report, and the chart as desired.
Query Builder Summary.
Combine tables.
Select only desired columns from tables.
Create columns with formulas and create reports.
Copy and paste the scripts of columns and reports into Post Query Script.
Scripting experience is not needed to build a Query Builder.
Creating a Query Builder is as simple as " point, click, drag and drop".
With this summary, that concludes my presentation.
Thank you.
