How to change Variable Text Length through Transformation node in Workspace?
Article ID: KB0074118
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.7 and higher |
Description
How to change variable text length through "transformation of variables" node in workspace?
Issue/Introduction
How to change Variable Text Length through Transformation node in Workspace?
Environment
Windows
Resolution
1. Go to "Node Browser" in the workspace, Under "All", find the "Transformation of Variables" node, load it to the workspace and link the upstream dataset spreadsheet to the Transformation node.
2. Double click on Transformation node to open the parameter dialog and click on "Edit Parameters"
3. Type in the transformation formula: for example
CreditHist2$[30] = "Credit Hist"
This is to create a new text variable "CreditHist2" of text length 30 with data copied from the original variable "Credit Hist".
4. Click OK and run the Transformation node.
The new variable "CreditHist2" of text length 30 will be added to the data spreadsheet.
The new spreadsheet generated from the transformation node could be used as input for downstream analysis.
Feedback
Yes
No
Powered by
