How to join multiple spreadsheets using SQL query in TIBCO Statistica Workspace?

How to join multiple spreadsheets using SQL query in TIBCO Statistica Workspace?

book

Article ID: KB0074261

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0 and higher

Description

This article introduce the "Query Spreadsheet node which allow user to join multiple spreadsheets by customizing SQL query in workspace.

 

Issue/Introduction

How to join multiple spreadsheets using SQL query in TIBCO Statistica Workspace?

Resolution

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.

Additional Information

Legacy Article ID: 229375, Created by Jenny based on the nice screenshots--- a signature of her!