How to use crosstab in Statistica Enterprise data configuration ?
Article ID: KB0082164
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and later versions |
Description
There is often need to un-stack stacked data while bringing back data into Statistica. One common use case for unstacking data is to merge limits from another data table. This article details how data in stacked format can be brought into Statistica as unstacked data using Statistica Enterprise data configuration.
Issue/Introduction
This article details how stacked data can be unstacked in Statistica Enterprise at the data configuration level using crosstab
Resolution
1. Launch Enterprise Manager as a user who has permissions to create a Data configuration (Data Admin)
2. Choose the folder to create the data configuration, right click and choose "New Data Configuration"
3. Define the database connection, query the stacked data and name the data configuration.
4. Expand the query to see all the fields. Define the crosstab column (equivalent of Code variable in Statistica's Unstack) , crosstab row (equivalent of CaseID variable in Statistica's Unstack), and crosstab value (equivalent of Unstack(value) variable in Statistica's Unstack) under the cross tab section for each field in the query.
5. Define Access permissions for the data configuration and commit the change by clicking on Commit button on the top left corner of the screen.
6. Click on Explore to view the data unstacked in Statistica.
Note : The equivalent of the above operation can also be performed within Statistica by using the unstack node.
Common use case : To combine limits stored in another table. Defining crosstab columns and then combining it with limits in another table by defining a join
2. Choose the folder to create the data configuration, right click and choose "New Data Configuration"
3. Define the database connection, query the stacked data and name the data configuration.
4. Expand the query to see all the fields. Define the crosstab column (equivalent of Code variable in Statistica's Unstack) , crosstab row (equivalent of CaseID variable in Statistica's Unstack), and crosstab value (equivalent of Unstack(value) variable in Statistica's Unstack) under the cross tab section for each field in the query.
5. Define Access permissions for the data configuration and commit the change by clicking on Commit button on the top left corner of the screen.
6. Click on Explore to view the data unstacked in Statistica.
Note : The equivalent of the above operation can also be performed within Statistica by using the unstack node.
Common use case : To combine limits stored in another table. Defining crosstab columns and then combining it with limits in another table by defining a join
Feedback
Yes
No
Powered by
