How to copy the case name of a TIBCO Statistica spreadsheet to a new variable ?

How to copy the case name of a TIBCO Statistica spreadsheet to a new variable ?

book

Article ID: KB0075647

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.3 and higher

Description

This article provides an example of how to transfer the case name to a variable in TIBCO Statistica Workspace and interactively.

Issue/Introduction

This article provides an example of how to transfer the case name to a variable by showing several alternative methods.

Environment

Windows 8.1, Windows 10, Windows Server 2008 R2, Windows Server 2012 R2, and Windows Server 2016

Resolution

METHOD 1 - TIBCO Statistica Workspace

Solution 1
When working with TIBCO Statistica workspaces, once we have the data set imported, we should be able to transfer the case name to a variable by using Transformations of Variables Node:
User-added image

Once you import this node to your workspace containing the data set, connect it, open the cog wheel of the node to edit the parameters and click on "Edit parameters" button to set the variable that needs to be updated with Case Names. Formula would go as follows: "Name=CaseName"
User-added image


Solution 2 
Alternative method would be to use Rules Builder node and create a rule that will do this for us:
User-added image

Here, in the parameters of the rules node make sure that you selected the Input Variables to copy to the output table:
User-added image

Please note: Workspace with demonstrated methods is attached. 

METHOD 2 - TIBCO Statistica Interactive Mode

Solution 1
When working with spreadsheet interactively, there is the possibility to transfer the case name to a variable by using the function "Names" (case Names manager) in Data|Names|Case Name Manager:
User-added image


Solution 2
Alternative solution would be to add a variable and define the formula. Once you have your data set opened, go to Data|Variables|Add... set the Variable name, i.e. "Names", it the formula section add Names=CaseName or V1=CaseName formula and click OK. 
User-added image
 

Attachments

How to copy the case name of a TIBCO Statistica spreadsheet to a new variable ? get_app