Products | Versions |
---|---|
Spotfire Statistica | 13.0 and higher |
1. Search and load the "Query spreadsheet" node from workspace "Node Browser". Multiple spreadsheet nodes can connect to the "Query spreadsheet" node as upstream input data files.
Double click on the Query Spreadsheet node to open the node parameter dialog, where "Statistica Query" and "Advanced Query Builder" options are available. User can click on the options to start the SQL query operations.
2. For example, Click on "Statistica Query", the standard query builder dialog opens. The box on the right top panel is by default in the "Graphic Mode", user can drag the data tables from the left panel list and drop to the box on the top right, and then do manual query operations. Corresponding SQL code will be automatically updated and shown under tab "SQL statement" in the bottom box.
Once query operations are done, user can click on the Green arrow button from the menu bar on the top to execute the SQL query.
3. If user prefers to manually write the SQL code, can click on the icon button on the left of the Green arrow button to switch from the "Graphic mode" to "Text mode". User can then draft their own SQL scripting code.
Once SQL scripting is done, click on the Green Arrow button to execute the query.
User can also click on the icon button besides the Green arrow button to switch back to the Graphic mode.