Can I use more than one query on a data file?
Yes. Multiple queries based on one or many different databases can be created to return data to an individual spreadsheet. After you create a query via Statistica Query and select Return Data to Statistica from the File menu, the Returning External Data to Spreadsheet dialog is displayed.
On this dialog, you can specify exactly where you want the returned data to be put on the spreadsheet. Therefore, you can specify that the first query returns data to Variable 1 and Case 1 of the current spreadsheet. Then you are able to create another query and specify that the data is returned to Variable 5, Case 1 of the same spreadsheet. In this manner, you can maintain connections to multiple external databases simultaneously.
Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.