How to rename case names using Statistica's Transformation Node
Article ID: KB0070834
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.0 and higher |
Description
If we want to copy the names in variable column 1 (V1) to the case names (V0), then we can use the Transformation node to perform this transformation.
Issue/Introduction
Workaround to Rename case names using Transformation Node
Environment
Windows OS
Resolution
Steps to Resolve:
1. Create a sample spreadsheet and enter the data.
2. Create the Macro and save the Macro.
3. Add the spreadsheet in the workspace and add the Transformation node.
4. Right-click on the Transformation node and click on Customize Outputs. Please refer the article( https://support.tibco.com/s/article/How-to-customize-node-outputs-in-a-wokspace) which shows how to customize the output.
5. Run the workspace to see the case names changed to the desired output.
If you still have any queries then you can contact us at https://support.tibco.com
1. Create a sample spreadsheet and enter the data.
2. Create the Macro and save the Macro.
Below is the macro content (where the "1" below represents Variable 1 that I want to get the case names from):
Dim S1 As Spreadsheet
Set S1 = ActiveDataSet
' Select Variable
S1.CaseNamesManager(, , scTransferToCase,1, False)
3. Add the spreadsheet in the workspace and add the Transformation node.
4. Right-click on the Transformation node and click on Customize Outputs. Please refer the article( https://support.tibco.com/s/article/How-to-customize-node-outputs-in-a-wokspace) which shows how to customize the output.
5. Run the workspace to see the case names changed to the desired output.
If you still have any queries then you can contact us at https://support.tibco.com
Additional Information
Feedback
Yes
No
Powered by
